{"id":2049,"date":"2023-10-22T20:08:02","date_gmt":"2023-10-22T20:08:02","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/"},"modified":"2023-12-06T05:50:19","modified_gmt":"2023-12-06T05:50:19","slug":"sorteertafel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/","title":{"rendered":"Hoe sorteer ik een array in vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2165919245\"><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>Om een array in VBA te sorteren, moet je een code schrijven waarin je het eerste element van de array kunt matchen met het volgende en deze kunt omwisselen als het eerste element eerder komt. Hiervoor heb je een <a href=\"https:\/\/exceladvisor.org\/nl\/voor-de-lus\/\">FOR (For Next)-lus<\/a> en de <a href=\"https:\/\/exceladvisor.org\/nl\/ucase\/\">UCASE-functie<\/a> nodig.<\/p><p> In deze tutorial zullen we de twee manieren (AZ en ZA) zien om de elementen van een array te sorteren.<\/p><h2 class=\"wp-block-heading\"> Sorteer een array (AZ)<\/h2><p> In de onderstaande code heb je een array met vijf elementen, en deze elementen hebben waarden vari\u00ebrend van E tot A, en nu moeten we in AZ-volgorde sorteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorteer-een-array-1\" width=\"415\" height=\"411\"><\/figure><\/div><p> <strong>Stappen om een array te sorteren<\/strong><\/p><ol type=\"1\"><li> Eerst moet u een geneste lus schrijven met For Next, waarbij u de boven- en ondergrenzen van de array gebruikt.<\/li><li> Daarna moet u in deze lus <a href=\"https:\/\/exceladvisor.org\/nl\/als-2\/\">de VBA IF-instructie<\/a> gebruiken om de twee elementen te vergelijken.<\/li><li> Als het eerste element v\u00f3\u00f3r het volgende element komt, moet u ze vanaf daar omwisselen door hun waarden in variabelen op te slaan.<\/li><li> Gebruik aan het einde het trefwoord \u2018Volgende\u2019 om de lus te voltooien. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boucles-imbriquees-avec-pour-les-2-suivantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"626\" height=\"324\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_a_to_z() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"E\" myArray(2) = \"D\" myArray(3) = \"C\" myArray(4) = \"B\" myArray(5) = \"A\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &gt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) End Sub<\/code><\/pre><p> Zorg ervoor dat u het <a href=\"https:\/\/exceladvisor.org\/nl\/onmiddellijke-vensterfoutopsporing-afdrukken\/\">venster Direct<\/a> activeert om daar de resultaten te zien.<\/p><h2 class=\"wp-block-heading\"> Sorteer een array (ZA)<\/h2><p> Op dezelfde manier kunt u sorteren op ZA. In de vorige methode vergeleken we het eerste element met het volgende element in de reeks, maar in deze code moet je het tegenovergestelde doen. Dus als het tweede element (volgende in volgorde) groter is dan het eerste, zal de code ze verwisselen.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_z_to_a() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"A\" myArray(2) = \"B\" myArray(3) = \"C\" myArray(4) = \"D\" myArray(5) = \"E\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &lt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) 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\/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-2049","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>\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en\" \/>\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\/sorteertafel\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-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\/sorteertafel\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/\",\"name\":\"\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"datePublished\":\"2023-10-22T20:08:02+00:00\",\"dateModified\":\"2023-12-06T05:50:19+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe sorteer ik een array in 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":"\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)","description":"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en","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\/sorteertafel\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)","og_description":"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en","og_url":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-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\/sorteertafel\/","url":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/","name":"\u25b7 Hoe sorteer ik een array in VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","datePublished":"2023-10-22T20:08:02+00:00","dateModified":"2023-12-06T05:50:19+00:00","description":"In deze zelfstudie leert u hoe u een array in VBA sorteert door het eerste element van de array te matchen met de volgende en","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/sorteertafel\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/sorteertafel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe sorteer ik een array in 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\/2049","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=2049"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2049\/revisions"}],"predecessor-version":[{"id":2709,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2049\/revisions\/2709"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}