{"id":2191,"date":"2023-09-25T15:00:15","date_gmt":"2023-09-25T15:00:15","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/loop\/"},"modified":"2023-09-25T15:00:15","modified_gmt":"2023-09-25T15:00:15","slug":"loop","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/loop\/","title":{"rendered":"Vba loops: panduan utama untuk pemula"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3729924113\"><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 class=\"wp-block-heading\"><strong>Poin penting<\/strong><\/p><ol><li> Menggunakan loop di VBA dapat berguna ketika Anda ingin melakukan tugas yang berulang.<\/li><li> Anda juga dapat menggunakan loop di dalam loop lain (bersarang).<\/li><li> Pastikan untuk berhati-hati saat membuat loop tak terbatas.<\/li><\/ol><h2 class=\"wp-block-heading\"> Apa itu LOOP di VBA?<\/h2><p> Di VBA, LOOP adalah struktur yang dapat mengulangi suatu instruksi. Sederhananya, sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk memulai lagi beberapa kali atau hingga suatu kondisi terpenuhi. Siklus eksekusi loop ini disebut iterasi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52033\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-loop-struktur1\" width=\"499\" height=\"299\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Jenis LOOP di VBA<\/h2><p> Di VBA, ada enam jenis loop berbeda yang dapat Anda gunakan, namun Anda juga dapat mendeskripsikannya dalam dua kategori dasar.<\/p><ol><li> <strong>Untuk Berikutnya<\/strong> : Untuk menggunakan FOR NEXT LOOP, Anda harus menetapkan angka sebagai penghitung berapa kali loop dijalankan. Jika Anda ingin mengulang 10 kali, Anda perlu menetapkan nilai ini untuk penghitung. <br><img loading=\"lazy\" decoding=\"async\" title=\"vba-untuk-loop berikutnya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-pour-la-boucle-suivante.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-for-next-loop\" width=\"521\" height=\"107\"><\/li><li> <strong>For Each<\/strong> : Dengan FOR EACH, Anda dapat menelusuri semua objek dalam koleksi objek. Karena setiap koleksi memiliki sejumlah objek, ini menjadikannya perulangan tetap.<\/li><li> <strong>Do While Loop<\/strong> : Menguji suatu kondisi, lalu terus melakukan aktivitas selama kondisi tersebut BENAR. Secara sederhana, pertama-tama ia menguji suatu kondisi dan hanya mengeksekusi pernyataan jika kondisi tersebut terpenuhi.<\/li><li> <strong>Do Loop While<\/strong> : Cara kerjanya sama seperti &#8216;Do While&#8217; tetapi ia mengulangi aktivitas terlebih dahulu lalu menguji kondisinya dan jika kondisinya BENAR maka aktivitas tersebut akan terus dilakukan.<\/li><li> <strong>Do Until Loop<\/strong> : Ini menguji suatu kondisi dan kemudian terus mengeksekusi pernyataan yang Anda tetapkan hingga kondisi tersebut FALSE dan saat kondisi tersebut menjadi TRUE, maka kondisi tersebut berhenti. Pada dasarnya, ini kebalikan dari &#8220;Lakukan Sementara&#8221;.<\/li><li> <strong>Loop Until<\/strong> : Cara kerjanya sama seperti \u201cDo Until\u201d, namun aktivitas ini diulangi terlebih dahulu, lalu pengujian kondisinya dan jika kondisinya FALSE maka aktivitas ini akan terus dilakukan.<\/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\/pilih-kasusnya\/\">VBA Pilih Kasus<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/untuk-melakukan-sementara\/\">Excel VBA Do While Loop dan (Do Loop While) \u2013 Panduan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/daun-lingkaran\/\">Ulangi semua lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/\">Ulangi suatu rentang menggunakan VBA (Kolom, Baris, dan Rentang Bekas)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">VBA FOR LOOP (Untuk Berikutnya, Untuk Masing-masing)<\/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":"closed","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2191","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>VBA Loops: Panduan Utama untuk Pemula di tahun 2023<\/title>\n<meta name=\"description\" content=\"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu\" \/>\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\/loop\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Loops: Panduan Utama untuk Pemula di tahun 2023\" \/>\n<meta property=\"og:description\" content=\"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/loop\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.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\/loop\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/loop\/\",\"name\":\"VBA Loops: Panduan Utama untuk Pemula di tahun 2023\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\",\"datePublished\":\"2023-09-25T15:00:15+00:00\",\"description\":\"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/loop\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/loop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/loop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba loops: panduan utama untuk pemula\"}]},{\"@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":"VBA Loops: Panduan Utama untuk Pemula di tahun 2023","description":"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu","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\/loop\/","og_locale":"id_ID","og_type":"article","og_title":"VBA Loops: Panduan Utama untuk Pemula di tahun 2023","og_description":"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu","og_url":"https:\/\/exceladvisor.org\/id\/loop\/","og_site_name":"Excel Advisor","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.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\/loop\/","url":"https:\/\/exceladvisor.org\/id\/loop\/","name":"VBA Loops: Panduan Utama untuk Pemula di tahun 2023","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png","datePublished":"2023-09-25T15:00:15+00:00","description":"Sebuah loop dapat melakukan satu atau lebih aktivitas dan kembali ke awal untuk mengulangi beberapa kali tertentu","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/loop\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/loop\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/loop\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-boucle-vba1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/loop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba loops: panduan utama untuk pemula"}]},{"@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\/2191","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=2191"}],"version-history":[{"count":0,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2191\/revisions"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}