{"id":2133,"date":"2023-09-30T03:47:06","date_gmt":"2023-09-30T03:47:06","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jika-tidak\/"},"modified":"2023-12-06T06:18:30","modified_gmt":"2023-12-06T06:18:30","slug":"jika-tidak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jika-tidak\/","title":{"rendered":"Bagaimana cara menggunakan jika tidak di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2400204529\"><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> , ia akan mengeksekusi sebaris kode jika kondisi yang Anda tentukan untuk diuji adalah TRUE. Namun saat Anda menggunakan operator NOT dengan IF, ia akan memeriksa apakah kondisi yang Anda tentukan tidak BENAR dan mengeksekusi kode berdasarkan kondisi tersebut.<\/p><p> <strong>Ini seperti melakukan kebalikan dari pernyataan IF, TRUE menjadi FALSE dan FALSE menjadi TRUE.<\/strong><\/p><p> Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini benar, IF akan mengembalikan TRUE, bukan? Namun jika menggunakan IF NOT A &lt; B, hasilnya akan FALSE.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> NOT adalah operator logika.<\/p><h2 class=\"wp-block-heading\"> <strong>Contoh penggunaan VBA JIKA TIDAK<\/strong><\/h2><p> Di sini kita akan melihat contoh sederhana untuk memahaminya: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57664\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\" sizes=\"auto, \" srcset=\"\" alt=\"contoh-untuk-menggunakan-vba-jika-tidak\" width=\"698\" height=\"493\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim A As Range, B As Range Set A = Range(\"A1\") Set B = Range(\"B1\") If Not A &lt; B Then MsgBox \"A is not greater than B.\" Else MsgBox \"B is not greater than A.\" End If End Sub<\/code><\/pre><p> Pada kode di atas, Anda menggunakan operator NOT untuk menguji apakah B tidak lebih besar dari A.<\/p><p> Jika Anda melihat pernyataan kondisi, Anda dapat memahami bahwa kondisi sebenarnya yang akan diuji adalah jika B lebih besar dari A, namun karena kita menggunakan pernyataan NOT, maka akan menghasilkan FALSE jika kondisinya TRUE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57662\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utilise-loperateur-not.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"524\" height=\"285\"><\/figure><\/div><p> Berikut contoh lain yang dapat Anda gunakan untuk memahaminya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() If Not ActiveSheet.Name = Sheets(\"Sheet1\").Name Then Sheets(\"Sheet1\").Activate End If End Sub<\/code><\/pre><p> Sekarang dalam kode ini, Anda menggunakan <strong>NOT dengan IF<\/strong> untuk melihat apakah sheet yang aktif adalah Sheet1 atau bukan, dan jika tidak, baris kode yang kami tentukan <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\">akan mengaktifkan Sheet1<\/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\/keluar-jika\/\">VBA Keluar JIKA<\/a><\/li><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\/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-2133","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 IF NOT di VBA di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...\" \/>\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\/jika-tidak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan IF NOT di VBA di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.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\/jika-tidak\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\",\"name\":\"Bagaimana cara menggunakan IF NOT di VBA di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"datePublished\":\"2023-09-30T03:47:06+00:00\",\"dateModified\":\"2023-12-06T06:18:30+00:00\",\"description\":\"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jika-tidak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jika-tidak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan jika tidak 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 IF NOT di VBA di Excel? (Tutorial 2023)","description":"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...","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\/jika-tidak\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan IF NOT di VBA di Excel? (Tutorial 2023)","og_description":"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...","og_url":"https:\/\/exceladvisor.org\/id\/jika-tidak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.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\/jika-tidak\/","url":"https:\/\/exceladvisor.org\/id\/jika-tidak\/","name":"Bagaimana cara menggunakan IF NOT di VBA di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","datePublished":"2023-09-30T03:47:06+00:00","dateModified":"2023-12-06T06:18:30+00:00","description":"Ini seperti melakukan pernyataan IF yang berlawanan, TRUE menjadi FALSE dan FALSE menjadi TRUE. Katakanlah Anda ingin menguji apakah A &lt; B, dan jika kondisi ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jika-tidak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jika-tidak\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jika-tidak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-exemple-pour-utiliser-vba-sinon.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jika-tidak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan jika tidak 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\/2133","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=2133"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2133\/revisions"}],"predecessor-version":[{"id":2731,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2133\/revisions\/2731"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}