{"id":4366,"date":"2023-07-11T16:15:05","date_gmt":"2023-07-11T16:15:05","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/"},"modified":"2023-07-11T16:15:05","modified_gmt":"2023-07-11T16:15:05","slug":"vba-jika-tidak-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/","title":{"rendered":"Vba: cara menggunakan &quot;jika tidak kosong&quot;"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>Not IsEmpty<\/strong> di VBA untuk memeriksa apakah sel tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut ini contoh bagaimana Anda bisa menggunakan sintaks ini di makro:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> IfNotBlank()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 13\n        <span style=\"color: #0000ff;\">If<\/span> Not IsEmpty(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) <span style=\"color: #0000ff;\">Then<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Cell is Not Empty<\/span> \u201d\n        <span style=\"color: #0000ff;\">Else<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Cell is Empty<\/span> \u201d\n        <span style=\"color: #0000ff;\">End If<\/span>\n    Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = Result\n    <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini memeriksa apakah setiap sel dalam rentang <strong>A2:A13<\/strong> tidak kosong, lalu mencetak &#8220;Sel tidak kosong&#8221; atau &#8220;Sel kosong&#8221; untuk setiap sel yang cocok dalam rentang <strong>B2:B13<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan \u201cJika tidak kosong\u201d di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34091 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/videvba1.jpg\" alt=\"\" width=\"496\" height=\"434\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin memeriksa apakah setiap sel dalam rentang <strong>A2:A13<\/strong> tidak kosong, lalu menampilkan hasilnya di sel terkait dalam rentang <strong>B2:B8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> IfNotBlank()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 13\n        <span style=\"color: #0000ff;\">If<\/span> Not IsEmpty(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) <span style=\"color: #0000ff;\">Then<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Cell is Not Empty<\/span> \u201d\n        <span style=\"color: #0000ff;\">Else<\/span>\n        Result = \u201c <span style=\"color: #ff0000;\">Cell is Empty<\/span> \u201d\n        <span style=\"color: #0000ff;\">End If<\/span>\n    Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = Result\n    <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34290 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/notempty1.jpg\" alt=\"\" width=\"465\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B memberi tahu kita apakah masing-masing sel terkait di kolom A kosong atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga bisa menggunakan makro berikut untuk sekadar mengembalikan nama tim itu sendiri di kolom B jika nilainya tidak kosong di kolom A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> IfNotBlank()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 13\n        <span style=\"color: #0000ff;\">If<\/span> Not IsEmpty(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) <span style=\"color: #0000ff;\">Then<\/span>\n        Result = Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i).Value\n        <span style=\"color: #0000ff;\">Else<\/span>\n        Result = \" <span style=\"color: #ff0000;\">Empty<\/span> \"\n        <span style=\"color: #0000ff;\">End If<\/span>\n    Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = Result\n    <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34291 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/notempty2.jpg\" alt=\"\" width=\"503\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom B sekarang mengembalikan nama tim di kolom A jika sel tidak kosong.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA <b>IsEmpty<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/isempty-function\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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-menghitung-kemunculan-karakter-dalam-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" target=\"_blank\" rel=\"noopener\">VBA: cara memeriksa apakah suatu string berisi string lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/\" target=\"_blank\" rel=\"noopener\">VBA: rumus untuk \u201cJika\u201d sel berisi\u201d<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan Not IsEmpty di VBA untuk memeriksa apakah sel tidak kosong. Berikut ini contoh bagaimana Anda bisa menggunakan sintaks ini di makro: Sub IfNotBlank() Dim i As Integer For i = 2 To 13 If Not IsEmpty(Range(&#8221; A &#8221; &amp; i)) Then Result = \u201c Cell is Not Empty \u201d Else Result = [&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>VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.\" \/>\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\/vba-jika-tidak-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T16:15:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/videvba1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/\",\"name\":\"VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T16:15:05+00:00\",\"dateModified\":\"2023-07-11T16:15:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan &quot;jika tidak kosong&quot;\"}]},{\"@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":"VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials","description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.","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\/vba-jika-tidak-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-11T16:15:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/videvba1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/","url":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/","name":"VBA: Cara menggunakan &quot;Jika tidak kosong&quot; - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T16:15:05+00:00","dateModified":"2023-07-11T16:15:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus &quot;jika tidak kosong&quot; di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan &quot;jika tidak kosong&quot;"}]},{"@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\/4366"}],"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=4366"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4366\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}