{"id":1528,"date":"2023-11-17T21:05:22","date_gmt":"2023-11-17T21:05:22","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/"},"modified":"2023-12-06T06:13:15","modified_gmt":"2023-12-06T06:13:15","slug":"meja-dengan-rantai","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/","title":{"rendered":"Bagaimana cara membuat array dengan string melalui vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2342008077\"><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>Di VBA, Anda dapat membuat array dengan string yang mana setiap elemen array menyimpan string yang dapat Anda akses lebih lanjut atau bahkan digabungkan menjadi satu string. Selain itu, Anda juga dapat membagi string utama menjadi beberapa substring (menggunakan pembatas) dan kemudian menyimpannya di elemen array.<\/p><p> Seperti yang saya katakan di atas, ada dua cara menggunakan string dalam array, dan dalam tutorial ini kita akan melihat cara menulis kode untuk keduanya.<\/p><h2 class=\"wp-block-heading\"> Array VBA dengan string<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_string_array() Dim myArray() As Variant myArray = Array(\"One\", \"Two\", \"Three\") Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) End Sub<\/code><\/pre><ol type=\"1\"><li> Pertama, deklarasikan sebuah array tanpa jumlah elemen yang ingin Anda simpan di dalamnya.<\/li><li> Selanjutnya, Anda perlu menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/menyebarkan\/\">fungsi ARRAY VBA<\/a> untuk menetapkan nilai yang ingin Anda tentukan.<\/li><li> Setelah itu, tentukan semua string menggunakan koma di fungsinya.<\/li><li> Pada akhirnya, Anda dapat mengakses semua saluran menggunakan nomor item. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-array-dengan-string-1\" width=\"486\" height=\"561\"><\/figure><\/div><p> Dengan cara yang sama, Anda juga bisa mendapatkan string sel untuk disimpan dalam tabel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57133\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-stocker-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"788\" height=\"562\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA membagi string dan menyimpannya dalam array<\/h2><p> Jika Anda menginginkan string yang memiliki banyak substring, Anda dapat membaginya menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/membelah\/\">fungsi SPLIT VBA<\/a> yang menggunakan pembatas.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_string_array() Dim myArray() As String myArray = Split(\"Today is a good day\", \" \") For i = LBound(myArray) To UBound(myArray) Debug.Print myArray(i) Next i End Sub<\/code><\/pre><p> Dalam kode ini Anda memiliki string yang merupakan frase lima kata. Dan saat Anda menggunakan fungsi split, itu membaginya menjadi lima substring berbeda dan kemudian Anda menyimpannya di elemen array.<\/p><p> Setelah itu Anda memiliki <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">loop for<\/a> yang menggunakan batas atas dan bawah untuk membuat loop penghitung dan mencetak setiap elemen array ke <a href=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\">window langsung<\/a> .<\/p><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\/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\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/susunan-lingkaran-vba\/\">Perulangan VBA dalam array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pantai-memiliki-lukisan\/\">Rentang VBA ke array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\">Tabel keluaran 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-1528","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 membuat array dengan string melalui VBA?<\/title>\n<meta name=\"description\" content=\"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub\" \/>\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-dengan-rantai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membuat array dengan string melalui VBA?\" \/>\n<meta property=\"og:description\" content=\"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-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-dengan-rantai\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/\",\"name\":\"\u25b7 Bagaimana cara membuat array dengan string melalui VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\",\"datePublished\":\"2023-11-17T21:05:22+00:00\",\"dateModified\":\"2023-12-06T06:13:15+00:00\",\"description\":\"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat array dengan string melalui 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 membuat array dengan string melalui VBA?","description":"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub","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-dengan-rantai\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membuat array dengan string melalui VBA?","og_description":"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub","og_url":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-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-dengan-rantai\/","url":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/","name":"\u25b7 Bagaimana cara membuat array dengan string melalui VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png","datePublished":"2023-11-17T21:05:22+00:00","dateModified":"2023-12-06T06:13:15+00:00","description":"di sini Anda akan mempelajari cara menggunakan string dalam array sebagai elemen dan Anda juga akan mempelajari cara membagi string menjadi sub","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-vba-avec-des-chaines-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat array dengan string melalui 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\/1528","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=1528"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1528\/revisions"}],"predecessor-version":[{"id":2276,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1528\/revisions\/2276"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}