{"id":1529,"date":"2023-11-17T21:02:46","date_gmt":"2023-11-17T21:02:46","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/"},"modified":"2023-12-06T06:13:56","modified_gmt":"2023-12-06T06:13:56","slug":"array-multidimensi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/","title":{"rendered":"Bagaimana cara membuat tabel multidimensi?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2491187891\"><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 membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda dapat menentukan dimensi sebanyak yang Anda inginkan (VBA mengizinkan 60 dimensi), tetapi Anda mungkin tidak perlu menggunakan lebih dari 2 atau 3 dimensi dari array mana pun. Menggunakan tabel dua dimensi seperti memiliki baris dan kolom.<\/p><p> Dalam tutorial ini kita akan melihat cara membuat array 2D dan 3D.<\/p><h2 class=\"wp-block-heading\"> Buat array multidimensi di VBA<\/h2><ol><li> Gunakan <a href=\"https:\/\/exceladvisor.org\/id\/lemah\/\">pernyataan Dim<\/a> untuk mendeklarasikan array dengan nama apa pun yang ingin Anda berikan. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-multidimensi-array-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"466\" height=\"212\"><\/li><li> Setelah itu, masukkan tanda kurung awal dan atur jumlah elemen untuk dimensi pertama. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-set-jumlah-elemen-2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-definir-le-nombre-delements-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"218\"><\/li><li> Selanjutnya, ketikkan perintah dan masukkan sejumlah item yang ingin Anda miliki di dimensi kedua, lalu tutup tanda kurung. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-masukkan-jumlah-item\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-un-nombre-delements.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"231\"><\/li><li> Pada akhirnya, tetapkan <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">tipe data<\/a> untuk tabel sebagai varian atau tipe data apa pun yang Anda inginkan. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-tabel-sebagai-varian-4\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-tableau-en-variante-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"512\" height=\"193\"><\/li><\/ol><p> Ini kodenya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_multi_dimensional_array() Dim myArray(5, 2) As Variant myArray(1, 1) = 1 myArray(2, 1) = 2 myArray(3, 1) = 3 myArray(4, 1) = 4 myArray(5, 1) = 5 myArray(1, 2) = 6 myArray(2, 2) = 7 myArray(3, 2) = 8 myArray(4, 2) = 9 myArray(5, 2) = 10 End Sub<\/code><\/pre><p> Kode tabel di atas membuat tabel dengan 5 baris dan 2 kolom dan akan terlihat seperti ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cree-un-tableau-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat-papan-5\" width=\"158\" height=\"121\"><\/figure><\/div><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\/menambahkan-array-nilai-baru\/\">VBA Tambahkan nilai baru ke array<\/a><\/li><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 class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1529","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>Bagaimana cara membuat tabel multidimensi menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa\" \/>\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\/array-multidimensi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat tabel multidimensi menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/\",\"name\":\"Bagaimana cara membuat tabel multidimensi menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"datePublished\":\"2023-11-17T21:02:46+00:00\",\"dateModified\":\"2023-12-06T06:13:56+00:00\",\"description\":\"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat tabel multidimensi?\"}]},{\"@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":"Bagaimana cara membuat tabel multidimensi menggunakan VBA?","description":"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa","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\/array-multidimensi\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat tabel multidimensi menggunakan VBA?","og_description":"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa","og_url":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/","url":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/","name":"Bagaimana cara membuat tabel multidimensi menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","datePublished":"2023-11-17T21:02:46+00:00","dateModified":"2023-12-06T06:13:56+00:00","description":"Untuk membuat array dengan banyak dimensi, Anda harus menentukan dimensinya saat mendeklarasikan array. Ya, Anda bisa","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/array-multidimensi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/array-multidimensi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat tabel multidimensi?"}]},{"@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\/1529","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=1529"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1529\/revisions"}],"predecessor-version":[{"id":2320,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1529\/revisions\/2320"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}