{"id":4776,"date":"2023-07-08T01:42:42","date_gmt":"2023-07-08T01:42:42","guid":{"rendered":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/"},"modified":"2023-07-08T01:42:42","modified_gmt":"2023-07-08T01:42:42","slug":"keluaran-vba-jika","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/","title":{"rendered":"Cara menggunakan pernyataan exit if di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tidak ada pernyataan <strong>Exit If<\/strong> bawaan di VBA, tetapi Anda dapat dengan mudah menyimulasikannya dengan menggunakan pernyataan <strong>If<\/strong> dengan pernyataan <strong>GoTo<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan pernyataan Exit IF di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat makro yang meminta pengguna memasukkan bilangan bulat kurang dari 10 dan kemudian menggunakan pernyataan <strong>IF<\/strong> untuk melakukan hal berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jika bilangan bulat yang dimasukkan kurang dari 10, kalikan dengan 2 dan tampilkan hasilnya di sel <strong>A1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jika bilangan bulat yang dimasukkan tidak kurang dari 10, keluar dari pernyataan IF dan menghasilkan pesan kesalahan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubMultiplySomeValue<\/span> ()\n\n<span style=\"color: #0000ff;\">Dim<\/span> inputInteger <span style=\"color: #0000ff;\">As<\/span> Integer\n     \n<span style=\"color: #008000;\">'get integer from user\n<\/span>inputInteger = InputBox(\" <span style=\"color: #ff0000;\">Please enter an integer less than 10<\/span> \")\n\n<span style=\"color: #008000;\">'check if integer is less than 10\n<\/span><span style=\"color: #0000ff;\">If<\/span> inputInteger &lt; 10 <span style=\"color: #0000ff;\">Then<\/span>\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \").Value = inputInteger * 2\n<span style=\"color: #0000ff;\">Else<\/span>\n<span style=\"color: #0000ff;\">GoTo<\/span> FlagMessage\n<span style=\"color: #0000ff;\">End If<\/span>\n\nFlagMessage:\nMsgBox \u201c <span style=\"color: #ff0000;\">This number is not less than 10<\/span> \u201d\n    \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Saat kita menjalankan makro ini, kita akan diminta memasukkan bilangan bulat kurang dari 10:.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita memasukkan nilai <strong>5<\/strong> lalu tekan <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37288 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sortieif1.png\" alt=\"\" width=\"526\" height=\"222\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Karena bilangan bulat ini kurang dari 10, sub-prosedur akan mengalikan nilai yang kita masukkan dengan 2 dan menampilkan hasilnya di sel <strong>A1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37289 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sortieif2.png\" alt=\"\" width=\"490\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun, misalkan kita memasukkan nilai <strong>15<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37290 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exitif3.png\" alt=\"\" width=\"481\" height=\"206\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menerima kotak pesan berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37291 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/exitif4.png\" alt=\"\" width=\"252\" height=\"203\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai yang kita masukkan tidak akan dikalikan 2 dan tidak ada hasil yang ditampilkan di sel <strong>A1<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/vba-pada-kesalahan-sub-keluaran\/\" target=\"_blank\" rel=\"noopener\">Cara keluar dari Sub karena kesalahan di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kesalahan-vba\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan IFERROR di VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hapus-file-vba\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus file menggunakan VBA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tidak ada pernyataan Exit If bawaan di VBA, tetapi Anda dapat dengan mudah menyimulasikannya dengan menggunakan pernyataan If dengan pernyataan GoTo . Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik. Contoh: Cara menggunakan pernyataan Exit IF di VBA Katakanlah kita ingin membuat makro yang meminta pengguna memasukkan bilangan bulat kurang dari 10 dan kemudian [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T01:42:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sortieif1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/\",\"url\":\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/\",\"name\":\"Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T01:42:42+00:00\",\"dateModified\":\"2023-07-08T01:42:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/keluaran-vba-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan pernyataan exit if di vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.","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:\/\/statorials.org\/id\/keluaran-vba-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/","og_site_name":"Statorials","article_published_time":"2023-07-08T01:42:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sortieif1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/","url":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/","name":"Cara Menggunakan Pernyataan Exit IF di VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T01:42:42+00:00","dateModified":"2023-07-08T01:42:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pernyataan exit IF di VBA, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/keluaran-vba-jika\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/keluaran-vba-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan pernyataan exit if di vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4776"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4776"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4776\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}