{"id":1975,"date":"2023-10-26T08:06:31","date_gmt":"2023-10-26T08:06:31","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/instr\/"},"modified":"2023-12-06T05:46:13","modified_gmt":"2023-12-06T05:46:13","slug":"instr","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/instr\/","title":{"rendered":"Hoe gebruik ik de vba instr-functie?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2012629405\"><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 VBA INSTR-functie wordt vermeld in de tekstcategorie van VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>retourneert het het startpositienummer van een substring (door u opgegeven) uit een andere string<\/strong> . In eenvoudige bewoordingen werkt het als de functies <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/excel-tekenreeksfuncties\/\">FIND<\/a> en <a href=\"https:\/\/exceladvisor.org\/nl\/excel-tekenreeksfuncties\/\">SEARCH<\/a> (spreadsheetfuncties).<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>InStr([Start], String1, String2, [Vergelijken])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>[Start]<\/strong> : Een geheel getal om de positie op te geven van waaruit u wilt beginnen met zoeken. [Dit is een optioneel argument en als u dit weglaat, wordt VBA standaard ingesteld op 1].<\/li><li> <strong>String1<\/strong> : De string waarin u wilt zoeken.<\/li><li> <strong>String2<\/strong> : De string waarnaar u wilt zoeken.<\/li><li> <strong>[Vergelijk]<\/strong> : een tekenreekswaarde om de vergelijking te defini\u00ebren die moet worden uitgevoerd bij het filteren van de array. [Dit is een optioneel argument en als dit wordt weggelaten, gebruikt VBA standaard vbBinaryCompare].<ul><li> vbBinaryCompare: voor binaire vergelijking.<\/li><li> vbTextCompare: voor tekstvergelijking.<\/li><li> vbDatabaseCompare: voor databasevergelijking.<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA INSTR-functie kunt gebruiken, moet u het onderstaande voorbeeld doorlopen waarin we er een vba-code mee hebben geschreven: <\/p><div class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" title=\"voorbeeld-vba-instr-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-instr-function\" width=\"838\" height=\"482\"><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_INSTR() Range(\"B1\").Value = InStr(Range(\"A1\"), \" \") End Sub<\/code><\/pre><p> In de bovenstaande code hebben we INSTR gebruikt om de spatie in de waarde (Mick Griffin) in cel A1 te vinden en deze retourneerde 5, met als resultaat dat er de eerste spatie is tussen &#8216;Mick&#8217; en &#8216;Griffin&#8217; waarvan de positie 5 is.<\/p><h2 class=\"wp-block-heading\"> Opmerkingen<\/h2><p> Hieronder staan enkele belangrijke punten waarmee u rekening moet houden bij het gebruik van de INSTR-functie in VBA.<\/p><ul><li> Als &#8220;string1&#8221; niet kan worden gevonden in &#8220;string2&#8221;, is het resultaat 0. <\/li><\/ul><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-240\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/strconv\/\">VBA STRCONV<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/snaar\/\">VBA-STRING<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/omgekeerd\/\">VBA STRE INVERSE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/trimmen\/\">VBA-TRIM<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ucase\/\">VBAUCASE<\/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-1975","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 INSTR-functie? (Syntaxis + voorbeeld)<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA INSTR-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\/instr\/\" \/>\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 INSTR-functie? (Syntaxis + voorbeeld)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA INSTR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/instr\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:46:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.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\/instr\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/instr\/\",\"name\":\"Hoe gebruik ik de VBA INSTR-functie? (Syntaxis + voorbeeld)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\",\"datePublished\":\"2023-10-26T08:06:31+00:00\",\"dateModified\":\"2023-12-06T05:46:13+00:00\",\"description\":\"Leer hoe u de VBA INSTR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/instr\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/instr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/instr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik de vba instr-functie?\"}]},{\"@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 INSTR-functie? (Syntaxis + voorbeeld)","description":"Leer hoe u de VBA INSTR-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\/instr\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA INSTR-functie? (Syntaxis + voorbeeld)","og_description":"Leer hoe u de VBA INSTR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/instr\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:46:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.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\/instr\/","url":"https:\/\/exceladvisor.org\/nl\/instr\/","name":"Hoe gebruik ik de VBA INSTR-functie? (Syntaxis + voorbeeld)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png","datePublished":"2023-10-26T08:06:31+00:00","dateModified":"2023-12-06T05:46:13+00:00","description":"Leer hoe u de VBA INSTR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/instr\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/instr\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/instr\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-instr.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/instr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik de vba instr-functie?"}]},{"@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\/1975","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=1975"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1975\/revisions"}],"predecessor-version":[{"id":2479,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1975\/revisions\/2479"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}