{"id":4337,"date":"2023-07-11T21:36:35","date_gmt":"2023-07-11T21:36:35","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/"},"modified":"2023-07-11T21:36:35","modified_gmt":"2023-07-11T21:36:35","slug":"vba-jika-sel-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/","title":{"rendered":"Vba: rumus sederhana untuk \u201cjika sel berisi\u201d"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menggunakan rumus “jika sel berisi” di VBA:<\/span><\/p>\n

 Sub<\/span> IfContains()\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 8\n        If<\/span> InStr(1, LCase(Range(\" A<\/span> \" & i)), \" turtle<\/span> \") <> 0 Then<\/span>\n        Result = \" Contains Turtle<\/span> \"\n        Else<\/span>\n        Result = \u201c Does Not Contain Turtle<\/span> \u201d\n        End If<\/span>\n    Range(\" B<\/span> \" & i) = Result\n    Next<\/span> i\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini memeriksa apakah setiap sel dalam rentang A2:A8<\/strong> berisi “turtle”, lalu menetapkan “Berisi kura-kura” atau “Tidak berisi kura-kura” ke setiap sel yang cocok dalam rentang B2:B8<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Metode Instr<\/strong> memeriksa apakah suatu string berisi string lain dan metode LCase<\/strong> mengubah teks menjadi huruf kecil untuk melakukan pencarian yang tidak peka huruf besar-kecil.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menggunakan \u201cJika sel berisi\u201d di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar sel berikut di Excel yang masing-masing berisi teks berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin memeriksa apakah setiap sel dalam rentang A2:A8<\/strong> berisi teks “turtle” dan menampilkan hasilnya di sel terkait dalam rentang B2:B8<\/strong> .<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> IfContains()\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 8\n        If<\/span> InStr(1, LCase(Range(\" A<\/span> \" & i)), \" turtle<\/span> \") <> 0 Then<\/span>\n        Result = \" Contains Turtle<\/span> \"\n        Else<\/span>\n        Result = \u201c Does Not Contain Turtle<\/span> \u201d\n        End If<\/span>\n    Range(\" B<\/span> \" & i) = Result\n    Next<\/span> i\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B memberi tahu kita apakah sel terkait di kolom A berisi \u201ckura-kura\u201d di suatu tempat dalam teks atau tidak.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA Instr<\/strong> di sini<\/a> .<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a>
 VBA: cara memeriksa apakah suatu string berisi string lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menggunakan rumus “jika sel berisi” di VBA: Sub IfContains() Dim i As Integer For i = 2 To 8 If InStr(1, LCase(Range(” A ” & i)), ” turtle “) <> 0 Then Result = ” Contains Turtle ” Else Result = \u201c Does Not Contain Turtle \u201d End […]<\/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":"\nVBA: rumus sederhana untuk "Jika sel berisi" - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" 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-sel-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: rumus sederhana untuk "Jika sel berisi" - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T21:36:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbacontain1.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=\"1 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-sel-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/\",\"name\":\"VBA: rumus sederhana untuk "Jika sel berisi" - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T21:36:35+00:00\",\"dateModified\":\"2023-07-11T21:36:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: rumus sederhana untuk \u201cjika sel berisi\u201d\"}]},{\"@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: rumus sederhana untuk "Jika sel berisi" - Statorial","description":"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" 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-sel-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: rumus sederhana untuk "Jika sel berisi" - Statorial","og_description":"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-11T21:36:35+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbacontain1.jpg"}],"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\/vba-jika-sel-berisi\/","url":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/","name":"VBA: rumus sederhana untuk "Jika sel berisi" - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T21:36:35+00:00","dateModified":"2023-07-11T21:36:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menulis rumus sederhana untuk "jika sel berisi" di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: rumus sederhana untuk \u201cjika sel berisi\u201d"}]},{"@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\/4337"}],"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=4337"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4337\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}