{"id":1572,"date":"2023-11-16T14:13:33","date_gmt":"2023-11-16T14:13:33","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/variabel-global\/"},"modified":"2023-12-06T06:16:25","modified_gmt":"2023-12-06T06:16:25","slug":"variabel-global","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/variabel-global\/","title":{"rendered":"Bagaimana cara mendeklarasikan variabel global di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1835122963\"><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, saat Anda mendeklarasikan variabel sebagai variabel global, Anda dapat menggunakannya dalam prosedur apa pun di modul apa pun. Seperti namanya, Anda bisa menggunakannya di seluruh dunia yang artinya ketersediaannya ada dimana-mana.<\/p><p> Jadi jika Anda memiliki variabel global di &#8220;module1&#8221; dan sekarang Anda ingin menggunakannya di modul2, Anda bisa menggunakannya.<\/p><h2 class=\"wp-block-heading\"> Deklarasikan variabel global di VBA<\/h2><ol type=\"1\"><li> Pertama, Anda perlu menggunakan kata kunci \u201cGlobal\u201d<\/li><li> Setelah itu, deklarasikan nama variabelnya.<\/li><li> Selanjutnya, ketik \u201cas\u201d untuk mendapatkan daftar tipe data.<\/li><li> Pada akhirnya, pilih tipe data yang ingin Anda deklarasikan untuk variabel tersebut. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60216\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"variabel-global-dalam-vba\" width=\"387\" height=\"526\"><\/figure><\/div><p> <strong>Komentar<\/strong><\/p><ol type=\"1\"><li> Saat Anda mendeklarasikan variabel global, Anda harus mendeklarasikannya sebelum menulis prosedur di modul, seperti yang Anda lihat pada contoh di atas.<\/li><li> Anda juga dapat menggunakan kata kunci &#8220;Publik&#8221; untuk mendeklarasikan variabel sebagai global.<\/li><\/ol><h2 class=\"wp-block-heading\"> Memahami ruang lingkup variabel<\/h2><p> Namun untuk memiliki pemahaman yang jelas tentang variabel global, Anda perlu memahami ruang lingkup variabel. Ada tiga cara untuk mendefinisikan cakupan variabel:<\/p><ol type=\"1\"><li> <strong>Tingkat Prosedur<\/strong> : Anda hanya dapat menggunakan variabel dalam prosedur yang sama tempat Anda mendeklarasikannya.<\/li><li> <strong>Tingkat modul (Pribadi)<\/strong> : Membuat variabel dapat diakses dari semua prosedur dalam modul.<\/li><li> <strong>Tingkat Global (Publik)<\/strong> : Membuat variabel dapat diakses dari semua prosedur di semua modul.<\/li><\/ol><p> Izinkan saya berbagi sesuatu dari dunia nyata dengan Anda untuk memperjelas hal ini kepada Anda. Saya bekerja di co-working space dan tempat saya duduk di lantai satu gedung tiga lantai, saya kebanyakan duduk di kursi yang sama setiap hari.<\/p><p> <strong>Saat Anda mendeklarasikan variabel dengan cakupan tingkat prosedur, Anda hanya dapat menggunakannya dalam prosedur yang sama.<\/strong><\/p><p> Sama seperti saya duduk di kursi yang sama di lantai yang sama setiap hari. Tapi izinkan saya memberi tahu Anda lebih banyak: meskipun saya duduk di lantai pertama, saya juga bisa menggunakan kursi mana pun di lantai lain.<\/p><p> Dan pada cuplikan di bawah, kami mendeklarasikan variabel \u201ciCon\u201d di bagian atas modul menggunakan kata kunci Private sebelum memulai prosedur apa pun dan saya menggunakannya di ketiga kode. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60217\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-a-declare-licone-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"dideklarasikan-ikon-variabel\" width=\"339\" height=\"546\"><\/figure><\/div><p> Bayangkan modul ini sebagai sebuah bangunan di mana Anda memiliki lantai yang berbeda (Prosedur) dan karena Anda telah mendeklarasikan variabel di awal modul, Anda dapat menggunakan salah satu prosedur dalam modul ini. Ini disebut cakupan privat tingkat modul.<\/p><p> <strong>Sekarang hal terakhirnya:<\/strong> Kantor saya memiliki cabang di berbagai kota di seluruh negeri dan jika saya pergi ke sana, saya dapat pergi ke kantor tersebut dan menggunakan kursi mana pun jika saya mau. Jadi jika Anda memiliki modul berbeda di buku kerja Anda, Anda bisa menggunakan satu variabel di semua modul ini dengan mendeklarasikannya sebagai Publik\/Global.<\/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\"> 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\/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\/konstanta\/\">VBA konstan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lemah\/\">Redupkan pernyataan VBA<\/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-1572","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 mendeklarasikan variabel global (publik) di VBA?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di\" \/>\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\/variabel-global\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mendeklarasikan variabel global (publik) di VBA?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/variabel-global\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-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\/variabel-global\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/\",\"name\":\"\u25b7 Bagaimana cara mendeklarasikan variabel global (publik) di VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png\",\"datePublished\":\"2023-11-16T14:13:33+00:00\",\"dateModified\":\"2023-12-06T06:16:25+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/variabel-global\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/variabel-global\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mendeklarasikan variabel global 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 mendeklarasikan variabel global (publik) di VBA?","description":"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di","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\/variabel-global\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mendeklarasikan variabel global (publik) di VBA?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di","og_url":"https:\/\/exceladvisor.org\/id\/variabel-global\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-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\/variabel-global\/","url":"https:\/\/exceladvisor.org\/id\/variabel-global\/","name":"\u25b7 Bagaimana cara mendeklarasikan variabel global (publik) di VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png","datePublished":"2023-11-16T14:13:33+00:00","dateModified":"2023-12-06T06:16:25+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara mendeklarasikan variabel global di VBA yang dapat digunakan di semua prosedur modul atau di","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/variabel-global\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/variabel-global\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/variabel-global\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-variable-globale-dans-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/variabel-global\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mendeklarasikan variabel global 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\/1572","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=1572"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1572\/revisions"}],"predecessor-version":[{"id":2532,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1572\/revisions\/2532"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}