{"id":2050,"date":"2023-10-22T19:48:52","date_gmt":"2023-10-22T19:48:52","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/"},"modified":"2023-12-06T05:51:28","modified_gmt":"2023-12-06T05:51:28","slug":"tabel-met-opzoekwaarden","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/","title":{"rendered":"Hoe vind ik een waarde in een array met vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1350754059\"><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>Wanneer u waarden in een array opslaat, kunnen er momenten zijn waarop u een array-lookup moet uitvoeren. In dit geval moet u weten welke methoden u kunt gebruiken. Bekijk nu de onderstaande code die u kan helpen begrijpen hoe u naar een waarde in een array kunt zoeken. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57290\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"vind-een-waarde-in-een-array-1\" width=\"709\" height=\"1456\"><\/figure><\/div><ol type=\"1\"><li> In het eerste deel van de code heb je <a href=\"https:\/\/exceladvisor.org\/nl\/variabelen\/\">variabelen<\/a> die je later in de code moet gebruiken.<\/li><li> Daarna <a href=\"https:\/\/exceladvisor.org\/nl\/willekeurig-nummer\/\">genereert het volgende deel willekeurige getallen<\/a> met behulp van <a href=\"https:\/\/exceladvisor.org\/nl\/rnd\/\">RND<\/a> om de tien waarden uit de array te halen.<\/li><li> Vervolgens kunt u in een invoervak de waarde invoeren waarnaar u in de tabel wilt zoeken.<\/li><li> Daarna hebt u een regel die de <a href=\"https:\/\/exceladvisor.org\/nl\/als-2\/\">IF-instructie<\/a> gebruikt om te controleren of de waarde die u in het invoervak hebt ingevoerd een getal is of niet.<\/li><li> In dit deel vindt u een code voor de string die u in het <a href=\"https:\/\/exceladvisor.org\/nl\/vba-berichtbox\/\">berichtvenster<\/a> kunt gebruiken als de door u ingevoerde waarde niet wordt gevonden.<\/li><li> Dit deel van de code gebruikt een <a href=\"https:\/\/exceladvisor.org\/nl\/voor-de-lus\/\">For (For Each)-lus<\/a> om <a href=\"https:\/\/exceladvisor.org\/nl\/array-grootte\/\">elk element in de array te doorlopen<\/a> en te controleren of de ingevoerde waarde in de array voorkomt of niet.<\/li><li> Het laatste deel van de code geeft een bericht weer dat aangeeft of de waarde is gevonden of niet.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_array_search() 'this section declares an array and variables 'that you need to search within the array. Dim myArray(10) As Integer Dim i As Integer Dim varUserNumber As Variant Dim strMsg As String 'This part of the code adds 10 random numbers to 'the array and shows the result in the 'immediate window as well. For i = 1 To 10 myArray(i) = Int(Rnd * 10) Debug.Print myArray(i) Next i 'it is an input box that asks 'you the number that you want to find Loopback: varUserNumber = InputBox _ (\"Enter a number between 1 and 10 to search for:\", _ \"Linear Search Demonstrator\") 'it's an if statement that checks for the value that you 'have entered in the input box. If varUserNumber = \"\" Then End If Not IsNumeric(varUserNumber) Then GoTo Loopback If varUserNumber &lt; 1 Or varUserNumber &gt; 10 Then GoTo Loopback 'message to show if the value doesn't found. strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was not found in the array.\" 'loop through the array and match each value with the 'the value you have entered in the input box. For i = 1 To UBound(myArray) If myArray(i) = varUserNumber Then strMsg = \"Your value, \" &amp; varUserNumber &amp; _ \", was found at position \" &amp; i &amp; \" in the array.\" Exit For End If Next i 'message box in the end MsgBox _ strMsg, vbOKOnly + vbInformation, _ \"Linear Search Result\" End Sub<\/code><\/pre><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\"> Meer informatie over <a href=\"https:\/\/exceladvisor.org\/nl\/schilderijen\/\">VBA-tabellen<\/a> <\/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\/voeg-een-nieuwe-reeks-waarden-toe\/\">VBA Voeg nieuwe waarde toe aan array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/array-grootte\/\">VBA-arraylengte (grootte)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tafel-met-kettingen\/\">VBA-array met tekenreeksen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/\">VBA Duidelijke array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/dynamische-tafel\/\">Dynamische tabel VBA<\/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-2050","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 vind ik een waarde in een array met VBA?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.\" \/>\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\/tabel-met-opzoekwaarden\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe vind ik een waarde in een array met VBA?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.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\/tabel-met-opzoekwaarden\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/\",\"name\":\"Hoe vind ik een waarde in een array met VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"datePublished\":\"2023-10-22T19:48:52+00:00\",\"dateModified\":\"2023-12-06T05:51:28+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe vind ik een waarde in een array met vba?\"}]},{\"@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 vind ik een waarde in een array met VBA?","description":"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.","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\/tabel-met-opzoekwaarden\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe vind ik een waarde in een array met VBA?","og_description":"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.","og_url":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.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\/tabel-met-opzoekwaarden\/","url":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/","name":"Hoe vind ik een waarde in een array met VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","datePublished":"2023-10-22T19:48:52+00:00","dateModified":"2023-12-06T05:51:28+00:00","description":"In deze zelfstudie leert u hoe u een array kunt doorzoeken met behulp van een lus.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-rechercher-une-valeur-dans-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/tabel-met-opzoekwaarden\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe vind ik een waarde in een array met vba?"}]},{"@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\/2050","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=2050"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2050\/revisions"}],"predecessor-version":[{"id":2840,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2050\/revisions\/2840"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}