{"id":2208,"date":"2023-09-02T06:07:44","date_gmt":"2023-09-02T06:07:44","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/"},"modified":"2023-12-06T05:50:52","modified_gmt":"2023-12-06T05:50:52","slug":"object-ondersteunt-deze-eigenschap-of-methodefout-438-niet","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/","title":{"rendered":"Hoe vba-fout 438 in excel op te lossen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-751654814\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>VBA-fout 438 treedt op wanneer u een eigenschap of methode probeert te gebruiken die dit object niet ondersteunt. Zoals u weet hebben alle objecten eigenschappen en methoden die u kunt gebruiken, maar er kan zich een situatie voordoen wanneer u een eigenschap of methode gebruikt die niet van toepassing is op een bepaald object.<\/p><p> <strong>Foutmelding:<\/strong><\/p><ul><li> VBA-object ondersteunt deze eigenschap- of methodefout niet (fout 438)<\/li><\/ul><p> Laten we een voorbeeld nemen om dit te begrijpen: bij het spreadsheetobject verschijnt een methode om het spreadsheet te selecteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57067\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\" sizes=\"auto, \" srcset=\"\" alt=\"eigenschap vba_object_does_not_support_this_\" width=\"368\" height=\"266\"><\/figure><\/div><p> Zoals u weet kunt u nu een werkmap activeren, maar er is geen methode die u kunt gebruiken om een werkmap te selecteren, omdat u geen werkmap kunt selecteren, maar deze alleen kunt activeren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57068\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2_activate_a_workbook.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"555\" height=\"421\"><\/figure><\/div><p> Dus wanneer u deze methode probeert te gebruiken met een werkmapobject, krijgt u runtimefout 438. Zelfs u kunt zien dat deze methode niet in de lijst met eigenschappen en methoden van het werkmapobject staat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57069\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3_runtime_error_438.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"562\" height=\"374\"><\/figure><\/div><p> Nu begrijpt u dat dit een fout kan zijn van de persoon die de code schrijft, en zelfs gemaakt kan worden als u bedreven bent in VBA.<\/p><p class=\"qt-tip\"> <strong>Opmerking:<\/strong> Wanneer u code in de nieuwste versie van Microsoft Excel hebt geschreven en deze nu in een oudere versie probeert uit te voeren, heeft die versie mogelijk geen methode of eigenschap voor het object dat u gebruikt. .<\/p><h2 class=\"wp-block-heading\"> Een object repareren dat deze eigenschap of methode niet ondersteunt<\/h2><p> De beste manier om deze fout 438 (object ondersteunt deze eigenschap of methode) af te handelen, is dat u moet weten welke eigenschappen en methoden worden ondersteund door het object dat u gebruikt.<\/p><p> Wanneer u een object definieert, kunt u de lijst met alle eigenschappen en methoden zien wanneer u een punt (.) typt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57070\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4_fix_object_doesnot_support_this_property.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"603\" height=\"349\"><\/figure><\/div><p> Deze lijst kan u helpen beslissen of de methode die u wilt gebruiken aanwezig is of niet. En als dat niet het geval is, moet u een andere manier vinden om code te schrijven voor de taak die u wilt volbrengen. Als alternatief kunt u ook de Objectbrowser (F2) openen om de eigenschappen en methoden te bekijken die u bij een object heeft.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/foutafhandeling\/\">VBA-foutafhandeling<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/automatiseringsfout-440\/\">VBA-automatiseringsfout (fout 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/fout-400\/\">VBA-fout 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ongeldige-procedureaanroep-of-argumentfout-5\/\">Ongeldige VBA-procedureaanroep of argumentfout (fout 5)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/object-vereiste-fout-424\/\">VBA-object vereiste fout (fout 424)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2208","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/\",\"name\":\"\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\",\"datePublished\":\"2023-09-02T06:07:44+00:00\",\"dateModified\":\"2023-12-06T05:50:52+00:00\",\"description\":\"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe vba-fout 438 in excel op te lossen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur","description":"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur","og_description":"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.","og_url":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/","url":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/","name":"\u25b7Hoe VBA-fout 438 oplossen? - Excel-adviseur","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","datePublished":"2023-09-02T06:07:44+00:00","dateModified":"2023-12-06T05:50:52+00:00","description":"In deze zelfstudie leert u waarom een ongeldig VBA-object deze eigenschap- of methodefout (fout 438) niet ondersteunt en hoe u hiermee omgaat tijdens het schrijven van VBA-code.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/object-ondersteunt-deze-eigenschap-of-methodefout-438-niet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe vba-fout 438 in excel op te lossen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=2208"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2208\/revisions"}],"predecessor-version":[{"id":2797,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2208\/revisions\/2797"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}