{"id":2159,"date":"2023-09-28T17:18:30","date_gmt":"2023-09-28T17:18:30","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/"},"modified":"2023-12-06T06:18:46","modified_gmt":"2023-12-06T06:18:46","slug":"tunggu-untuk-tidur","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/","title":{"rendered":"Bagaimana cara menggunakan perintah tunggu dan tidur di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-939147109\"><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 id=\"0-vba-wait-command\" class=\"wp-block-heading\">Perintah tunggu VBA<\/h2><p> Di VBA, perintah (metode) WAIT membantu Anda untuk menunggu semua aktivitas yang Anda lakukan di Excel dalam waktu tertentu atau hingga waktu tertentu. Sederhananya, Anda dapat membuat VBA menunggu selama beberapa detik, menit, atau bahkan berjam-jam, atau hingga waktu yang ditentukan. Ini memiliki argumen yang mengharuskan Anda untuk menentukannya.<\/p><h2 id=\"1-steps-to-use-vba-wait\" class=\"wp-block-heading\"> Langkah-langkah menggunakan VBA Tunggu<\/h2><ol type=\"1\"><li> Pertama, gunakan kata kunci &#8220;Aplikasi&#8221; dan ketikkan titik (.) untuk mendapatkan daftar properti dan metode.<\/li><li> Setelah itu, pilih atau ketuk metode \u201cTunggu\u201d.<\/li><li> Sekarang tentukan argumen &#8220;Waktu&#8221; untuk memberi tahu VBA berapa lama Anda ingin menunggu.<\/li><li> Terakhir, jalankan kode untuk mengantri semua aktivitas di Excel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55797\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"perintah vba-tunggu\" width=\"702\" height=\"311\"><\/figure><\/div><p> Dalam kode ini, Anda menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/sekarang\/\">SEKARANG<\/a> dan <a href=\"https:\/\/exceladvisor.org\/id\/nilai-waktu\/\">TIMEVALUE<\/a> ( <a href=\"https:\/\/exceladvisor.org\/id\/fungsi\/\">Fungsi VBA<\/a> ) untuk memberi tahu VBA agar menunggu sepuluh detik sejak Anda menjalankan kode. Jadi setelah sepuluh detik berlalu, pernyataan IF akan menguji kondisi dan mengeksekusi dengan menampilkan kotak pesan dengan pesan \u201cTunggu Berakhir\u201d.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_wait_example() If Application.Wait(Now + TimeValue(\"00:00:10\")) = True Then MsgBox \"Wait Over\" End If End Sub<\/code><\/pre><p> Anda juga bisa menggunakan metode Tunggu untuk membiarkan Excel menunggu semua aktivitas hingga waktu tertentu. Kode berikut menunggu hingga pukul 13.00 Jadi karena sistem saya sekarang pukul 12.52, kode baris ini akan membuatnya menunggu selama 8 menit berikutnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.Wait \"13:00:00\"<\/code><\/pre><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Dengan metode menunggu, Anda hanya dapat menunggu minimal satu detik.<\/p><h2 id=\"2-vba-sleep\" class=\"wp-block-heading\"> VBA Tidur<\/h2><p> Tidur adalah fungsi Windows ( <em>di bawah file DLL Windows; Anda perlu mengimpor fungsi ini menggunakan pernyataan kode<\/em> ) yang dapat membantu Anda menjeda atau menambahkan penundaan saat <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan makro<\/a> . Dalam fungsi ini Anda dapat menentukan waktu dalam milidetik, tetapi Anda tidak dapat menghentikan fungsi tidur setelah semuanya dijeda.<\/p><h2 id=\"3-use-sleep-function-in-vba\" class=\"wp-block-heading\"> Gunakan fungsi tidur di VBA<\/h2><ol type=\"1\"><li> Pertama-tama, Anda perlu menggunakan pernyataan kode untuk mengimpor fungsi tidur dari \u201c <em>perpustakaan kernel32<\/em> \u201d.<\/li><li> Dan kemudian Anda perlu memastikan untuk menambahkan pernyataan \u201cPtrSafe\u201d jika Anda menggunakan Excel 64-bit.<\/li><li> Maka Anda perlu memanggil fungsi tidur dalam kode.<\/li><li> Pada akhirnya, tentukan waktu (milidetik) Anda ingin menunda kode. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55798\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/02-fonction-de-veille-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"891\" height=\"391\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">If VBA7 Then ' <code>For 64-Bit versions of Excel<\/code> <code>Public Declare PtrSafe Sub Sleep Lib \"kernel32\" (ByVal dwMilliseconds As LongPtr)<\/code> Else 'For 32-Bit versions of Excel Public Declare Sub Sleep Lib \"kernel32\" (ByVal dwMilliseconds As Long) End If Sub vba_sleep() Sleep (10000) 'add code here MsgBox \"Finished\" End Sub<\/code><\/pre><p> Pada kode di atas Anda memiliki 10.000 milidetik, yang sama dengan 10 detik. Saat Anda menjalankan kode ini, kode ini akan tertunda selama 10 detik dan kemudian menampilkan kotak pesan.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Saat Anda menggunakan fungsi tidur, fungsi ini menghentikan semua yang ada di Excel selama waktu yang Anda tetapkan, Anda bahkan tidak dapat memutusnya. Pastikan untuk memeriksa tautan ini dari Microsoft tentang <a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/developer\/office-2010\/ee691831(v=office.14)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">kompatibilitas antara versi 32-bit dan 64-bit<\/a> .<\/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\/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-2159","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 menggunakan perintah tunggu dan tidur di VBA?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan\" \/>\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\/tunggu-untuk-tidur\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan perintah tunggu dan tidur di VBA?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-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\/tunggu-untuk-tidur\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan perintah tunggu dan tidur di VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png\",\"datePublished\":\"2023-09-28T17:18:30+00:00\",\"dateModified\":\"2023-12-06T06:18:46+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan perintah tunggu dan tidur 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 menggunakan perintah tunggu dan tidur di VBA?","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan","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\/tunggu-untuk-tidur\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan perintah tunggu dan tidur di VBA?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan","og_url":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-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\/tunggu-untuk-tidur\/","url":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/","name":"\u25b7 Bagaimana cara menggunakan perintah tunggu dan tidur di VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png","datePublished":"2023-09-28T17:18:30+00:00","dateModified":"2023-12-06T06:18:46+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan perintah wait dan sleep untuk menunda semua aktivitas di Excel menggunakan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-commande-dattente-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tunggu-untuk-tidur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan perintah tunggu dan tidur 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\/2159","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=2159"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2159\/revisions"}],"predecessor-version":[{"id":2767,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2159\/revisions\/2767"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}