{"id":2143,"date":"2023-09-29T00:37:26","date_gmt":"2023-09-29T00:37:26","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/konstanta\/"},"modified":"2023-12-06T06:12:50","modified_gmt":"2023-12-06T06:12:50","slug":"konstanta","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/konstanta\/","title":{"rendered":"Apa yang dimaksud dengan konstanta di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1098527757\"><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, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda, namun nilai yang Anda tetapkan tidak dapat diubah saat kode dijalankan. Di VBA, ada dua jenis konstanta berbeda yang dapat Anda gunakan:<\/p><ul><li> Konstanta intrinsik<\/li><li> Konstanta yang ditentukan pengguna<\/li><\/ul><p> <strong>Konstanta intrinsik<\/strong> adalah konstanta yang dibangun ke dalam bahasa VBA itu sendiri (misalnya, konstanta bawaan vbOKCancel yang Anda gunakan di <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> ), dan di sisi lain, <strong>konstanta yang ditentukan pengguna<\/strong> adalah konstanta yang dapat Anda buat dengan menetapkan a nilai untuk itu.<\/p><h2 class=\"wp-block-heading\"> Deklarasikan konstanta di VBA<\/h2><ol type=\"1\"><li> Gunakan kata kunci \u201cConst\u201d.<\/li><li> Tentukan nama untuk konstanta.<\/li><li> Gunakan kata kunci \u201cAs\u201d setelah namanya.<\/li><li> Tentukan \u201cTipe Data\u201d untuk konstanta berdasarkan nilai yang ingin Anda tetapkan padanya.<\/li><li> Sama dengan tanda \u201c=\u201d.<\/li><li> Pada akhirnya, nilai yang ingin Anda berikan padanya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"nyatakan-konstan-di-vba\" width=\"483\" height=\"267\"><\/figure><\/div><p> Di atas adalah konstanta yang menyimpan tanggal lahir. Sekarang jika menurut Anda tanggal lahir adalah sesuatu yang seharusnya tetap dan untuk jenis nilai ini Anda dapat menggunakan konstanta.<\/p><h2 class=\"wp-block-heading\"> Ruang lingkup konstanta<\/h2><p> Konstanta mempunyai cakupan yang sama dengan <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">variabel<\/a> . Saat Anda mendeklarasikan sebuah konstanta, ia memiliki cakupan tingkat prosedur, artinya Anda dapat menggunakannya di mana saja dalam prosedur. Tapi Anda bisa mendeklarasikan konstanta menggunakan lingkup privat atau publik.<\/p><p> Konstanta privat hanya tersedia untuk prosedur yang dinyatakan sebagai konstanta. Untuk mendeklarasikan konstanta privat, Anda harus menggunakan kata kunci \u201cPrivate\u201d, seperti pada contoh berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Private Const iName As String = \u201cPuneet\u201d<\/code><\/pre><p> Demikian pula, Anda harus menggunakan kata kunci \u201cPublik\u201d ketika Anda perlu mendeklarasikan sebuah konstanta sebagai publik.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Public Const iPrice As String = \u201c$3.99\u201d<\/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\/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 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-2143","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 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda\" \/>\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\/konstanta\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/konstanta\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/konstanta\/\",\"name\":\"\u25b7 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\",\"datePublished\":\"2023-09-29T00:37:26+00:00\",\"dateModified\":\"2023-12-06T06:12:50+00:00\",\"description\":\"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/konstanta\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/konstanta\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apa yang dimaksud dengan konstanta 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 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)","description":"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda","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\/konstanta\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)","og_description":"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda","og_url":"https:\/\/exceladvisor.org\/id\/konstanta\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-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\/konstanta\/","url":"https:\/\/exceladvisor.org\/id\/konstanta\/","name":"\u25b7 Konstanta VBA: Cakupan dan Deklarasi (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png","datePublished":"2023-09-29T00:37:26+00:00","dateModified":"2023-12-06T06:12:50+00:00","description":"Di VBA, konstanta adalah kotak penyimpanan yang disimpan di sistem Anda dan dapat menyimpan nilai di sana untuk Anda","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/konstanta\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/konstanta\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/konstanta\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-declarer-une-constante-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/konstanta\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Apa yang dimaksud dengan konstanta 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\/2143","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=2143"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2143\/revisions"}],"predecessor-version":[{"id":2249,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2143\/revisions\/2249"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}