{"id":1987,"date":"2023-10-25T05:39:19","date_gmt":"2023-10-25T05:39:19","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/isobject\/"},"modified":"2023-12-06T05:57:22","modified_gmt":"2023-12-06T05:57:22","slug":"isobject","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/isobject\/","title":{"rendered":"Hoe de vba isobject-functie gebruiken?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2158393736\"><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>De ISOBJECT VBA-functie wordt vermeld in de informatiecategorie VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>evalueert het de opgegeven expressie en retourneert TRUE als het een object is, anders FALSE<\/strong> . In eenvoudige bewoordingen kan het controleren of de opgegeven waarde een object is of niet, en op basis daarvan TRUE of FALSE retourneren.<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>IsObject(Expressie)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>Expressie<\/strong> : een expressie waarvan u wilt testen of het een object is of niet.<\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA ISOBJECT-functie kunt gebruiken, moet u het onderstaande voorbeeld doorlopen waarin we er een vba-code mee hebben geschreven: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"voorbeeld-vba-isobject-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-isobject-function\" width=\"840\" height=\"454\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_ISOBJECT() Dim myOB As Object Range(\"A1\").Value = IsObject(myOB) End Sub<\/code><\/pre><p> In de bovenstaande code hebben we ISOBJECT gebruikt om te controleren of de myOB een object is of niet. Omdat we myOB al als object hadden gedeclareerd, retourneerde de code TRUE in het resultaat. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Meer tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-192\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/isarray\/\">VBA ISARRAY<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/isdatum\/\">VBA ISDAAT<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-leeg\/\">VBA ISEMTE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/is-een-fout\/\">VBA-ISFOUT<\/a><\/li><\/ul><\/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-1987","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>Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\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\/isobject\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/isobject\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:57:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.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=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/isobject\/\",\"name\":\"Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png\",\"datePublished\":\"2023-10-25T05:39:19+00:00\",\"dateModified\":\"2023-12-06T05:57:22+00:00\",\"description\":\"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/isobject\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/isobject\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe de vba isobject-functie gebruiken?\"}]},{\"@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":"Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)","description":"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","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\/isobject\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)","og_description":"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/isobject\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:57:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/isobject\/","url":"https:\/\/exceladvisor.org\/nl\/isobject\/","name":"Hoe gebruik ik de VBA ISOBJECT-functie? (Syntaxis + voorbeeld)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png","datePublished":"2023-10-25T05:39:19+00:00","dateModified":"2023-12-06T05:57:22+00:00","description":"Leer hoe u de VBA ISOBJECT-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/isobject\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/isobject\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/isobject\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-isobject.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/isobject\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe de vba isobject-functie gebruiken?"}]},{"@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\/1987","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=1987"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1987\/revisions"}],"predecessor-version":[{"id":2377,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1987\/revisions\/2377"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}