{"id":2140,"date":"2023-09-29T01:41:24","date_gmt":"2023-09-29T01:41:24","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/keluar-jika\/"},"modified":"2023-12-06T06:18:49","modified_gmt":"2023-12-06T06:18:49","slug":"keluar-jika","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/keluar-jika\/","title":{"rendered":"Bagaimana cara menggunakan pernyataan if di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1513961304\"><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>Di VBA, saat Anda menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">pernyataan IF<\/a> , Anda bisa menggunakan pernyataan GoTo untuk keluar dari IF. Izinkan saya menjelaskan di sini; tidak ada pernyataan keluar terpisah yang dapat Anda gunakan dengan IF untuk keluar. Jadi akan lebih baik jika Anda menggunakan goto untuk keluar dari IF sebelum baris pernyataan akhir muncul.<\/p><p> Mari kita ambil contoh untuk memahami hal ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57658\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-keluar-jika\" width=\"620\" height=\"512\"><\/figure><\/div><p> Pada contoh di atas, seperti yang Anda lihat, kami menggunakan pernyataan IF untuk memeriksa apakah ada nilai di sel A1 atau tidak. Ketika Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan kode ini<\/a> dan tidak ada nilai di A1, VBA beralih ke &#8220;Lable1&#8221; dan mengeksekusi kode di bawah ini. Sehingga akan muncul kotak input untuk memasukkan nilai pada sel A1.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If Range(\"A1\") = \"\" Then GoTo Lable1 Else MsgBox \"there's a value in the cell.\" End If Lable1: Range(\"A1\").Value = _ InputBox(\"Enter Value\") End Sub<\/code><\/pre><p class=\"grey-note\"> Akan ada beberapa situasi di mana Anda harus keluar dari pernyataan IF saat menulis kode VBA. Seperti yang Anda ketahui dalam pernyataan IF tunggal, hanya ada dua kondisi, dan jika salah satu kondisi benar, VBA akan mengeksekusi kode yang Anda sebutkan dan kemudian keluar dari pernyataan secara otomatis.<\/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\/jika-2\/\">VBA JIKA (JIKA maka yang lain)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-dan\/\">VBA JIKA Dan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\">VBA JIKA TIDAK<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/saya-untuk\/\">VBA JIKA ATAU<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sarang-jika\/\">IF bersarang 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-2140","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 pernyataan IF di VBA? (Tutorial 2023)<\/title>\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\/keluar-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan pernyataan IF di VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/keluar-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/\",\"name\":\"Bagaimana cara menggunakan pernyataan IF di VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\",\"datePublished\":\"2023-09-29T01:41:24+00:00\",\"dateModified\":\"2023-12-06T06:18:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/keluar-jika\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/keluar-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan pernyataan if 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":"Bagaimana cara menggunakan pernyataan IF di VBA? (Tutorial 2023)","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\/keluar-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan pernyataan IF di VBA? (Tutorial 2023)","og_url":"https:\/\/exceladvisor.org\/id\/keluar-jika\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/","url":"https:\/\/exceladvisor.org\/id\/keluar-jika\/","name":"Bagaimana cara menggunakan pernyataan IF di VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","datePublished":"2023-09-29T01:41:24+00:00","dateModified":"2023-12-06T06:18:49+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/keluar-jika\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sortie-vba-si.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/keluar-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan pernyataan if 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\/2140","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=2140"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2140\/revisions"}],"predecessor-version":[{"id":2773,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2140\/revisions\/2773"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}