{"id":2142,"date":"2023-09-29T01:09:10","date_gmt":"2023-09-29T01:09:10","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/"},"modified":"2023-12-06T06:18:47","modified_gmt":"2023-12-06T06:18:47","slug":"pergi-ke-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/","title":{"rendered":"Bagaimana cara menggunakan pernyataan goto dalam kode vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3967828112\"><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>Pernyataan VBA GoTo membantu eksekusi kode menavigasi ke baris tertentu dalam prosedur. Secara sederhana, dengan pernyataan goto, VBA melompat ke baris tertentu yang telah Anda tentukan. Misalnya, jika Anda menentukan untuk melompat ke baris kedua, go akan melompat ke baris tersebut.<\/p><h2 class=\"wp-block-heading\"> Cara menggunakan pernyataan VBA GoTo dalam kode<\/h2><ol type=\"1\"><li> Pertama, Anda perlu menggunakan pernyataan goto.<\/li><li> Setelah itu Anda perlu menentukan ke mana Anda ingin VBA pergi dari goto.<\/li><li> Selanjutnya, buat tag untuk membuat tempat ini di prosedur.<\/li><li> Pada akhirnya, tambahkan baris kode yang ingin Anda jalankan. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-pergi-ke-pernyataan-dalam-kode\" width=\"593\" height=\"446\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_goto() GoTo <strong>Last<\/strong> <strong>Range<\/strong> (\"A1\"). <strong>Select<\/strong> <strong>Last<\/strong> : <strong>Range<\/strong> (\"A12\"). <strong>Select<\/strong> <strong>End<\/strong> Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> GoTo untuk mengulangi kode<\/h2><p> Anda juga dapat menggunakan pernyataan go to untuk mengulang kode menggunakan serangkaian kondisi.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> goto_repeat() <strong>Dim<\/strong> iMessage As String Question:    iMessage = InputBox(\"what's the day today?\") <strong>If<\/strong> iMessage &lt;&gt; \"tuesday\" <strong>Then<\/strong>    MsgBox (\"wrong answer, try again.\") <strong>GoTo<\/strong> Question <strong>Else<\/strong>    MsgBox (\"that's the right answer.\") <strong>End<\/strong> <strong>If<\/strong> <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Ketika Anda menjalankan kode di atas, ia akan menanyakan nama hari itu dan jika Anda memasukkan selain &#8220;Selasa&#8221;, ia akan mengulangi pertanyaan tersebut. Jika Anda melihat kodenya, Anda dapat melihat bahwa kita perlu menggunakan pernyataan goto dan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan if<\/a> .<\/p><p> Sekarang, ketika pengguna memasukkan apa pun selain jawaban yang benar, pernyataan goto memaksa VBA untuk mengulangi kode tersebut. (tetapi setiap kali Anda menggunakan kode jenis ini, Anda harus sangat berhati-hati karena dapat menciptakan perulangan tanpa akhir.<\/p><h2 class=\"wp-block-heading\"> VBA Lanjut ke akhir<\/h2><p> Anda juga dapat keluar dari sub menggunakan pernyataan goto. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-59664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-vba-aller-a-la-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-pergi ke akhir\" width=\"461\" height=\"198\"><\/figure><\/div><p> Pada kode di atas, kita telah menggunakan tag &#8220;terakhir&#8221; tepat sebelum pernyataan akhir dan ketika VBA mencapai pernyataan GoTo, itu membuat VBA melompat ke &#8220;Terakhir&#8221; di akhir prosedur.<\/p><h2 class=\"wp-block-heading\"> Pernyataan GoTo untuk menuju ke baris di subrutin lain<\/h2><p> Nah, pernyataan going to cukup berguna untuk membuat VBA melompat dari satu tempat ke tempat lain, tetapi tidak mungkin untuk melompat ke prosedur lain dalam <a href=\"https:\/\/exceladvisor.org\/id\/modul\/\">modul<\/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\/loop\/\">Loop VBA (Pemula hingga Mahir)<\/a><\/li><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><\/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-2142","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 pernyataan GoTo dalam kode VBA?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.\" \/>\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\/pergi-ke-1\/\" \/>\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 pernyataan GoTo dalam kode VBA?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.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\/pergi-ke-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan pernyataan GoTo dalam kode VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png\",\"datePublished\":\"2023-09-29T01:09:10+00:00\",\"dateModified\":\"2023-12-06T06:18:47+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan pernyataan goto dalam kode 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 pernyataan GoTo dalam kode VBA?","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.","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\/pergi-ke-1\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan pernyataan GoTo dalam kode VBA?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.","og_url":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:47+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.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\/pergi-ke-1\/","url":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/","name":"\u25b7 Bagaimana cara menggunakan pernyataan GoTo dalam kode VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png","datePublished":"2023-09-29T01:09:10+00:00","dateModified":"2023-12-06T06:18:47+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pernyataan GoTo dalam kode VBA untuk menavigasi ke baris tertentu dalam kode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/pergi-ke-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-aller-a-linstruction-dans-le-code.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/pergi-ke-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan pernyataan goto dalam kode 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\/2142","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=2142"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2142\/revisions"}],"predecessor-version":[{"id":2769,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2142\/revisions\/2769"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}