{"id":2050,"date":"2023-10-22T20:08:02","date_gmt":"2023-10-22T20:08:02","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/"},"modified":"2023-12-06T06:18:34","modified_gmt":"2023-12-06T06:18:34","slug":"meja-penyortiran","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/","title":{"rendered":"Bagaimana cara mengurutkan array di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-410097640\"><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>Untuk mengurutkan array di VBA, Anda perlu menulis kode di mana Anda dapat mencocokkan elemen pertama array dengan elemen berikutnya dan menukarnya jika elemen pertama ada sebelumnya. Anda memerlukan <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">loop FOR (For Next)<\/a> untuk ini dan <a href=\"https:\/\/exceladvisor.org\/id\/ucase\/\">fungsi UCASE<\/a> .<\/p><p> Dalam tutorial ini, kita akan melihat dua cara (AZ dan ZA) dalam mengurutkan elemen array.<\/p><h2 class=\"wp-block-heading\"> Mengurutkan array (AZ)<\/h2><p> Pada kode di bawah ini, Anda memiliki array dengan lima elemen, dan elemen ini memiliki nilai mulai dari E hingga A, dan sekarang kita perlu mengurutkan dalam urutan AZ. <\/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=\"sortir-an-array-1\" width=\"415\" height=\"411\"><\/figure><\/div><p> <strong>Langkah-langkah untuk mengurutkan array<\/strong><\/p><ol type=\"1\"><li> Pertama, Anda perlu menulis loop bersarang dengan For Next menggunakan batas atas dan bawah array.<\/li><li> Setelah itu, dalam loop ini, Anda perlu menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan VBA IF<\/a> untuk membandingkan kedua elemen.<\/li><li> Dari sana, jika elemen pertama harus berada sebelum elemen berikutnya, Anda perlu menukarnya dengan menyimpan nilainya dalam variabel.<\/li><li> Pada akhirnya, gunakan kata kunci \u201cBerikutnya\u201d untuk menyelesaikan perulangan. <\/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> Pastikan untuk mengaktifkan <a href=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\">jendela Immediate<\/a> untuk melihat hasilnya di sana.<\/p><h2 class=\"wp-block-heading\"> Urutkan array (ZA)<\/h2><p> Dengan cara yang sama, Anda dapat mengurutkan berdasarkan ZA. Pada metode sebelumnya, kita membandingkan elemen pertama dengan elemen berikutnya dalam urutan, tetapi dalam kode ini Anda perlu melakukan yang sebaliknya. Jadi jika elemen kedua (urutan berikutnya) lebih besar dari elemen pertama, kode akan menukarnya.<\/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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Pelajari lebih lanjut tentang <a href=\"https:\/\/exceladvisor.org\/id\/lukisan\/\">tabel VBA<\/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\/id\/ukuran-susunan\/\">Panjang array VBA (ukuran)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/\">Array VBA dengan string<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/\">Array Hapus VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\">VBA tabel dinamis<\/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>\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan\" \/>\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\/id\/meja-penyortiran\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:34+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=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\",\"name\":\"\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#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-06T06:18:34+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#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\/id\/meja-penyortiran\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengurutkan array di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)","description":"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan","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\/id\/meja-penyortiran\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan","og_url":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:34+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":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/","url":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/","name":"\u25b7 Bagaimana cara mengurutkan array di VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#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-06T06:18:34+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara mengurutkan array di VBA dengan mencocokkan elemen pertama array dengan elemen berikutnya dan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/meja-penyortiran\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/#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\/id\/meja-penyortiran\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengurutkan array di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2050"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2050\/revisions"}],"predecessor-version":[{"id":2742,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2050\/revisions\/2742"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}