{"id":2137,"date":"2023-09-29T02:43:45","date_gmt":"2023-09-29T02:43:45","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/lemah\/"},"modified":"2023-12-06T06:16:30","modified_gmt":"2023-12-06T06:16:30","slug":"lemah","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/lemah\/","title":{"rendered":"Bagaimana cara menggunakan dim di vba di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2754111826\"><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> <h2 class=\"wp-block-heading\">Apa itu deklarasi DIM VBA?<\/h2><p> Pernyataan VBA DIM berarti \u201cdeklarasikan\u201d yang harus Anda gunakan saat Anda perlu mendeklarasikan suatu variabel. Saat Anda menggunakannya, ia memberitahu VBA bahwa Anda mendeklarasikan nama tertentu sebagai variabel dengan menetapkan tipe data tertentu. Ini dapat digunakan untuk mendeklarasikan hal berikut:<\/p><ul><li> Variabel dasar<\/li><li> Varian<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/objek\/\">Objek<\/a><\/li><li> Menyebarkan<\/li><\/ul><h2 class=\"wp-block-heading\"> Gunakan Pernyataan DIM di VBA<\/h2><ol type=\"1\"><li> Ketikkan kata kunci \u201cRedupkan\u201d di awal.<\/li><li> Setelah itu masukkan nama variabel yang ingin digunakan.<\/li><li> Kemudian Anda perlu menggunakan kata &#8220;suka&#8221; dan Anda akan mendapatkan daftar <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">tipe data<\/a> instan.<\/li><li> Pada akhirnya, pilih tipe data yang ingin Anda tetapkan ke variabel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55786\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"dim-pernyataan-di-vba\" width=\"490\" height=\"380\"><\/figure><\/div><p> Seperti yang saya katakan, ketika Anda mendeklarasikan suatu variabel, Anda perlu menetapkan tipe datanya. Lihat cuplikan berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55787\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-attribuer-un-type-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"491\" height=\"384\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Mendeklarasikan beberapa variabel dengan satu pernyataan Dim<\/h2><p> Saat Anda perlu mendeklarasikan beberapa variabel, Anda dapat melakukannya menggunakan pernyataan Dim hanya sekali. Perhatikan contoh berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55788\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-variables-multiples-avec-une-instruction-dim.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"568\" height=\"367\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan opsi eksplisit<\/h2><p> Ini sangat disarankan untuk mendeklarasikan semua variabel yang meningkatkan kinerja kode Anda dan juga meningkatkan efisiensinya. Namun jika Anda melewatkan mendeklarasikan variabel dan kemudian menggunakannya dalam beberapa kode, VBA akan mengambil variabel tersebut sebagai varian.<\/p><p> Cara terbaik agar tidak melewatkan deklarasi variabel adalah dengan menggunakan pernyataan Option Explicit yang memaksa Anda untuk mendeklarasikan variabel dan menampilkan kesalahan setiap kali Anda melewatkannya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55789\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-en-utilisant-loption-explicite.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"520\" height=\"325\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Redupkan instruksi dengan tabel<\/h2><p> Anda juga harus menggunakan pernyataan DIM ketika Anda perlu mendeklarasikan sebuah array. Perhatikan contoh berikut yang saya bagikan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55790\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Instruction-5-dim-avec-tableaux.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"469\" height=\"388\"><\/figure><\/div><p> Pada contoh di atas, Anda memiliki dua <a href=\"https:\/\/exceladvisor.org\/id\/lukisan\/\">array<\/a> yang dideklarasikan dengan pernyataan dim.<\/p><p> Di array pertama Anda memiliki tiga elemen dan di array kedua tidak ada elemen yang dideklarasikan. <strong>Inilah saatnya<\/strong> Anda perlu mendeklarasikan array, Anda perlu menggunakan tanda kurung untuk mendeklarasikan elemen array dan tanda kurung kosong jika Anda menginginkan <a href=\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\">array dinamis<\/a> .<\/p><h2 class=\"wp-block-heading\"> Gunakan DIM dengan objek Excel<\/h2><p> Anda juga dapat merujuk ke suatu <a href=\"https:\/\/exceladvisor.org\/id\/objek\/\">objek<\/a> menggunakan pernyataan DIM. Misalkan Anda ingin menghitung lembar dalam buku kerja, Anda bisa mendeklarasikan objek ini dan menghitung lembar kerja darinya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55791\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-dim-avec-des-objets-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"671\" height=\"416\"><\/figure><\/div><p> Pada contoh di atas, Anda mendeklarasikan wb sebagai <a href=\"https:\/\/exceladvisor.org\/id\/bahan-pengikat\/\">buku kerja<\/a> dan kemudian mendefinisikan buku kerja &#8220;book1&#8221; untuk digunakan nanti dalam kode.<\/p><h2 class=\"wp-block-heading\"> Di mana harus meletakkan deklarasi Dim?<\/h2><p> Anda dapat mendeklarasikan variabel menggunakan pernyataan DIM di mana pun dalam kode, namun pastikan untuk mendeklarasikannya sebelum menggunakannya. Jadi katakanlah Anda mengacu pada variabel pada baris 2 kode dan Anda menggunakan Dim pada baris 3 untuk mendeklarasikan, Anda akan mendapatkan kesalahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55792\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-declarer-une-variable-en-utilisant-dim.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"595\" height=\"399\"><\/figure><\/div><p> Jadi pastikan Anda mendeklarasikan variabel sebelum menggunakannya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55793\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-declarer-une-variable-avant-de-lutiliser.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"612\" height=\"387\"><\/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\"> Tutorial terkait <\/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\/variabel-global\/\">Deklarasikan variabel global (publik) di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/\">Gunakan rentang atau sel sebagai variabel di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/opsi-eksplisit-2\/\">Pernyataan opsi eksplisit di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\">Variabel dalam kotak pesan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">Variabel VBA (deklarasikan, tipe data, dan cakupan)<\/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-2137","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 menggunakan Dim di VBA di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.\" \/>\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\/lemah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan Dim di VBA di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/lemah\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.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\/lemah\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/lemah\/\",\"name\":\"Bagaimana cara menggunakan Dim di VBA di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png\",\"datePublished\":\"2023-09-29T02:43:45+00:00\",\"dateModified\":\"2023-12-06T06:16:30+00:00\",\"description\":\"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lemah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/lemah\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lemah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan dim di vba di excel?\"}]},{\"@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 menggunakan Dim di VBA di Excel? (Tutorial 2023)","description":"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.","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\/lemah\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan Dim di VBA di Excel? (Tutorial 2023)","og_description":"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.","og_url":"https:\/\/exceladvisor.org\/id\/lemah\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.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\/lemah\/","url":"https:\/\/exceladvisor.org\/id\/lemah\/","name":"Bagaimana cara menggunakan Dim di VBA di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png","datePublished":"2023-09-29T02:43:45+00:00","dateModified":"2023-12-06T06:16:30+00:00","description":"Anda perlu menggunakan pernyataan dim untuk mendeklarasikan variabel dan tipe datanya saat menulis kode VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/lemah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/lemah\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/lemah\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-instruction-dim-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/lemah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan dim di vba di excel?"}]},{"@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\/2137","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=2137"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2137\/revisions"}],"predecessor-version":[{"id":2539,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2137\/revisions\/2539"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}