{"id":2163,"date":"2023-09-27T16:13:55","date_gmt":"2023-09-27T16:13:55","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/"},"modified":"2023-12-06T06:19:04","modified_gmt":"2023-12-06T06:19:04","slug":"kotak-pesan-variabel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/","title":{"rendered":"Bagaimana cara menggunakan variabel dalam kotak pesan?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3189693689\"><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>Anda juga dapat menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">variabel<\/a> di kotak pesan. Katakanlah Anda memiliki variabel yang menyimpan nilai tertentu dalam variabel tersebut.<\/p><p> Anda sekarang dapat menggunakan variabel ini di <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> untuk menampilkan nilai kepada pengguna. Dalam contoh berikut kita telah menggunakan makro di mana kita telah menggunakan perulangan for dan kita memiliki fungsi untuk <a href=\"https:\/\/exceladvisor.org\/id\/angka-acak\/\">menghasilkan angka acak<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-variabel-kotak pesan\" width=\"760\" height=\"486\"><\/figure><\/div><p> Saat Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan kode ini<\/a> , kode ini diulang 10 kali, lalu menghasilkan nomor acak dan menyimpan nomor tersebut dalam variabel. Pada baris kode berikut, kami telah menggunakan variabel yang sama untuk menampilkan nilai di kotak pesan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60696\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"161\" height=\"191\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub generateRandomNumber() Dim i As Integer, rNumber As Integer i = 10 For i = 1 To i rNumber = WorksheetFunction.RandBetween(1000, 2000) MsgBox rNumber Next i 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\"> 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\/lemah\/\">Redupkan instruksi VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">Variabel VBA (deklarasikan, tipe data, dan cakupan)<\/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-2163","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 variabel dalam kotak pesan?<\/title>\n<meta name=\"description\" content=\"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu\" \/>\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\/kotak-pesan-variabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan variabel dalam kotak pesan?\" \/>\n<meta property=\"og:description\" content=\"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\",\"name\":\"Bagaimana cara menggunakan variabel dalam kotak pesan?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"datePublished\":\"2023-09-27T16:13:55+00:00\",\"dateModified\":\"2023-12-06T06:19:04+00:00\",\"description\":\"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan variabel dalam kotak pesan?\"}]},{\"@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 variabel dalam kotak pesan?","description":"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu","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\/kotak-pesan-variabel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan variabel dalam kotak pesan?","og_description":"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu","og_url":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.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\/kotak-pesan-variabel\/","url":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/","name":"Bagaimana cara menggunakan variabel dalam kotak pesan?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","datePublished":"2023-09-27T16:13:55+00:00","dateModified":"2023-12-06T06:19:04+00:00","description":"Anda juga dapat menggunakan variabel di kotak pesan. Katakanlah Anda memiliki variabel itu","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan variabel dalam kotak pesan?"}]},{"@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\/2163","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=2163"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2163\/revisions"}],"predecessor-version":[{"id":2805,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2163\/revisions\/2805"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}