{"id":2193,"date":"2023-09-25T11:06:02","date_gmt":"2023-09-25T11:06:02","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/"},"modified":"2023-12-06T06:16:00","modified_gmt":"2023-12-06T06:16:00","slug":"bilah-status-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/","title":{"rendered":"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1471070997\"><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, terdapat properti \u201cStatus Bar\u201d yang dapat membantu Anda menampilkan nilai di status bar dan ada juga \u201cDisplayStatusBar\u201d untuk menyembunyikan dan menampilkan status jendela Excel. Saat menggunakan properti ini, Anda harus mengatur ulang bilah status sampai akhir, jika tidak, pesan atau pengaturan terakhir akan tetap ada.<\/p><p> Dalam tutorial kita akan melihat beberapa contoh yang bisa kita gunakan saat bekerja di Excel.<\/p><h2 class=\"wp-block-heading\"> Tampilkan nilai di bilah status<\/h2><p> Seperti yang saya katakan, Anda dapat menggunakan properti StatusBar untuk menampilkan nilai di bilah status. Pada kode di bawah ini, Anda telah menggunakan nilai &#8220;Halo&#8221; untuk ditambahkan ke bilah status. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55620\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png\" sizes=\"auto, \" srcset=\"\" alt=\"menampilkan nilai di bilah status\" width=\"431\" height=\"390\"><\/figure><\/div><ol type=\"1\"><li> Gunakan kata kunci \u201cAplikasi\u201d untuk merujuk pada aplikasi Excel.<\/li><li> Ketikkan titik untuk mendapatkan daftar properti dan metode.<\/li><li> Pilih properti \u201cStatusBar\u201d.<\/li><li> Pada akhirnya, gunakan tanda sama dengan untuk menentukan nilai yang ingin Anda tampilkan di bilah status.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_status_bar() Application.StatusBar = \"Hello\" End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Sembunyikan bilah status menggunakan VBA<\/h2><p> Sekarang anggaplah jika Anda ingin menyembunyikan bilah status, Anda dapat menggunakan DisplayStatusBar dan menentukan properti ini ke &#8220;False&#8221; ( <em>pertimbangkan kode berikut<\/em> ). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55621\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-masquer-la-barre-detat.png\" sizes=\"auto, \" srcset=\"\" alt=\"Sembunyikan bilah status\" width=\"484\" height=\"270\"><\/figure><\/div><ol type=\"1\"><li> Gunakan kata kunci \u201cAplikasi\u201d untuk merujuk pada aplikasi Excel.<\/li><li> Ketikkan titik untuk mendapatkan daftar properti dan metode.<\/li><li> Pilih properti \u201cDisplayStatusBar\u201d.<\/li><li> Pada akhirnya, gunakan tanda sama dengan untuk menentukan \u201cFalse\u201d.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_status_bar_hide() Application.DisplayStatusBar = False End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Perbarui kemajuan di bilah status<\/h2><p> Eksekusi kode selanjutnya menampilkan penghitung kemajuan pada bilah status menggunakan angka dari 1 hingga 100, yang dapat Anda ubah sesuai kebutuhan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_status_bar_update() Dim x As Integer Dim iTimer As Double 'you can change the loop if you need For x = 1 To 100 'dummy loop to run, you can change it as well iTimer = Timer Do Loop While Timer - MyTimer &lt; 0.03 Application.StatusBar = \"Progress: \" &amp; x &amp; \" of 100: \" &amp; Format(x \/ 100, \"Percent\") DoEvents Next x Application.StatusBar = False End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Poin penting untuk diingat<\/h2><ol type=\"1\"><li> Anda perlu menggunakan &#8220;aplikasi&#8221; dengan properti bilah status untuk menggunakannya.<\/li><li> Setelah Anda melihat pesan tentang status, Anda perlu menghapus pesan itu.<\/li><\/ol><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\/sorot-nilai-duplikat\/\">Sorot nilai duplikat menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ekstrak-hyperlink\/\">Ekstrak alamat hyperlink (URL) VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bidang-masuk\/\">Kotak masukan di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/file-teks\/\">VBA membuat dan menulis ke file teks<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pembaruan-layar\/\">Pembaruan Layar 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-2193","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 menampilkan\/menyembunyikan bilah status menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau\" \/>\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\/bilah-status-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.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\/bilah-status-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/\",\"name\":\"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png\",\"datePublished\":\"2023-09-25T11:06:02+00:00\",\"dateModified\":\"2023-12-06T06:16:00+00:00\",\"description\":\"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan 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":"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan VBA?","description":"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau","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\/bilah-status-1\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan VBA?","og_description":"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau","og_url":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.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\/bilah-status-1\/","url":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/","name":"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png","datePublished":"2023-09-25T11:06:02+00:00","dateModified":"2023-12-06T06:16:00+00:00","description":"Saat menggunakan properti bilah status, Anda harus menyetel ulang bilah status ke akhir, jika tidak, pesan terakhir atau","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bilah-status-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-valeur-dans-la-barre-detat.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bilah-status-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menampilkan\/menyembunyikan bilah status menggunakan 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\/2193","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=2193"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2193\/revisions"}],"predecessor-version":[{"id":2480,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2193\/revisions\/2480"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}