{"id":2138,"date":"2023-09-29T02:30:39","date_gmt":"2023-09-29T02:30:39","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/"},"modified":"2023-12-06T06:18:58","modified_gmt":"2023-12-06T06:18:58","slug":"keluaran-di-bawah","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/","title":{"rendered":"Bagaimana cara menggunakan sub keluar vba di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3306117766\"><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>VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui, setiap baris adalah makro yang berjalan satu demi satu, dan saat Anda menambahkan VBA &#8220;Keluar Sub&#8221;, keluar dari prosedur tanpa menjalankan sisa kode yang muncul setelahnya. Ini bekerja paling baik dengan <a href=\"https:\/\/exceladvisor.org\/id\/loop\/\">loop<\/a> dan <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> .<\/p><h2 class=\"wp-block-heading\"> Menggunakan Sub Pernyataan Keluar di VBA<\/h2><ol type=\"1\"><li> Pertama, tentukan baris mana yang ingin Anda tambahkan \u201cExit Sub\u201d.<\/li><li> Setelah itu, periksa struktur kode yang akan dieksekusi saat Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan kode tersebut<\/a> .<\/li><li> Selanjutnya masuk ke \u201cExit Sub\u201d.<\/li><li> Pada akhirnya, yang terbaik adalah memberikan <a href=\"https:\/\/exceladvisor.org\/id\/komentar\/\">komentar<\/a> yang menjelaskan mengapa Anda menggunakan pernyataan &#8220;Keluar Sub&#8221;. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55808\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-keluar-sub-pernyataan\" width=\"683\" height=\"373\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Dalam <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-yang-ditentukan-pengguna-2\/\">prosedur fungsi<\/a> VBA, pernyataan yang harus Anda gunakan adalah &#8220;Fungsi Keluar&#8221;.<\/p><h2 class=\"wp-block-heading\"> Gunakan Sub Keluar dengan Kotak Pesan dan Kotak Input<\/h2><p> Misalkan Anda ingin mendapatkan masukan dari pengguna dengan kotak masukan dan keluar dari prosedur jika respons pengguna bukan angka (perhatikan contoh berikut). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55809\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sorties-sub-avec-une-boite-de-message.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"686\" height=\"312\"><\/figure><\/div><p> Pada kode di atas Anda memiliki <a href=\"https:\/\/exceladvisor.org\/id\/isnumerik\/\">ISNUMERIC<\/a> yang memeriksa nilai yang dimasukkan dalam kotak input apakah itu angka atau bukan, dan jika nilai itu bukan angka maka menggunakan pernyataan Keluar Sub untuk menyelesaikan prosedur setelah menampilkan kotak pesan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_exit_sub_example() If IsNumeric(InputBox(\"Enter your age.\", \"Age\")) = False Then MsgBox \"Error! Enter your Age in numbers only.\" Exit Sub Else MsgBox \"Thanks for the input.\" End If End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Jika terjadi kesalahan, Keluar dari Sub<\/h2><p> Salah satu hal terbaik tentang &#8220;Keluar Sub&#8221;, Anda dapat menggunakannya untuk keluar dari prosedur ketika terjadi kesalahan. Di bawah ini adalah kode yang membagi angka dengan nol yang mengembalikan \u201cRuntime Error &#8217;11\u2032\u201d dan menghentikan eksekusi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55810\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sur-erreur-sortie-sous.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"491\" height=\"334\"><\/figure><\/div><p> Di sini Anda dapat menggunakan pernyataan GoTo untuk membuat penangan kesalahan dengan &#8220;Exit Sub&#8221; untuk keluar dari prosedur (pertimbangkan kode berikut). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55811\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-linstruction-goto.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"520\" height=\"381\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_exit_sub_on_error() On Error GoTo iError Range(\"A1\") = 10 \/ 0 iError: MsgBox \"You can't divide with the zero.\" &amp; _ \"Change the code.\" Exit Sub End Sub<\/code><\/pre><p> Pada kode di atas Anda memiliki penangan kesalahan, &#8220;iError&#8221; dengan kotak pesan, lalu pernyataan &#8220;Exit Sub&#8221;. Ketika kesalahan terjadi selama perhitungan, pernyataan goto diteruskan ke penangan kesalahan ( <a href=\"https:\/\/exceladvisor.org\/id\/penanganan-kesalahan\/\">VBA Error Handling<\/a> ) dan keluar dari prosedur.<\/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\/pertanyaan-wawancara\/\">Pertanyaan Wawancara VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/komentar\/\">Tambahkan komentar dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jeda-baris\/\">Tambahkan jeda baris dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-baru\/\">Tambahkan baris baru (carriage return) dalam string di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan Makro di Excel (Jalankan Kode VBA)<\/a><\/li><\/ul><\/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-2138","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 menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,\" \/>\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\/keluaran-di-bawah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-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\/keluaran-di-bawah\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/\",\"name\":\"Bagaimana cara menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\",\"datePublished\":\"2023-09-29T02:30:39+00:00\",\"dateModified\":\"2023-12-06T06:18:58+00:00\",\"description\":\"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan sub keluar vba di excel?\"}]},{\"@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 menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)","description":"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,","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\/keluaran-di-bawah\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)","og_description":"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,","og_url":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-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\/keluaran-di-bawah\/","url":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/","name":"Bagaimana cara menggunakan Sub Keluar VBA di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png","datePublished":"2023-09-29T02:30:39+00:00","dateModified":"2023-12-06T06:18:58+00:00","description":"VBA Exit Sub adalah pernyataan yang Anda gunakan untuk keluar dari subprosedur atau fungsi. Seperti yang Anda ketahui,","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-instruction-de-sortie-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/keluaran-di-bawah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan sub keluar vba di excel?"}]},{"@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\/2138","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=2138"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2138\/revisions"}],"predecessor-version":[{"id":2793,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2138\/revisions\/2793"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}