{"id":4973,"date":"2023-07-05T17:12:29","date_gmt":"2023-07-05T17:12:29","guid":{"rendered":"https:\/\/statorials.org\/id\/suka-vba\/"},"modified":"2023-07-05T17:12:29","modified_gmt":"2023-07-05T17:12:29","slug":"suka-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/suka-vba\/","title":{"rendered":"Cara menggunakan operator like di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan operator Suka<\/b> di VBA untuk menentukan apakah suatu string berisi pola tertentu.<\/span><\/p>\n

Misalnya, Anda dapat menggunakan sintaks berikut untuk memeriksa apakah setiap string dalam rentang sel A2:A10<\/strong> berisi substring “panas” dan menampilkan hasilnya dalam rentang B2:B10<\/strong> :<\/span><\/p>\n

 SubCheckLike<\/span> ()\n\nDim<\/span> i As<\/span> Integer\n    \nFor<\/span> i = 2 To<\/span> 10\n    If<\/span> Range(\"A\" & i) Like<\/span> \"*hot*\"<\/span> Then<\/span>\n        Range(\"B\" & i) = \"Contains hot\"<\/span>\n    Else<\/span>\n        Range(\"B\" & i) = \"Does not contain hot\"<\/span>\n    End If<\/span>\nNext<\/span> i\n    \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menggunakan operator Like di VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar makanan berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita bisa membuat makro berikut untuk memeriksa apakah setiap string di kolom A berisi substring “panas” dan menampilkan hasilnya di kolom B:<\/span><\/p>\n
 SubCheckLike<\/span> ()\n\nDim<\/span> i As<\/span> Integer\n    \nFor<\/span> i = 2 To<\/span> 10\n    If<\/span> Range(\"A\" & i) Like<\/span> \"*hot*\" Then<\/span>\n        Range(\"B\" & i) = \"Contains hot\"\n    Else<\/span>\n        Range(\"B\" & i) = \"Does not contain hot\"\n    End If<\/span>\nNext<\/span> i\n    \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B menunjukkan apakah setiap sel yang cocok di kolom A berisi substring “panas” atau tidak.<\/span><\/p>\n
 Perhatikan bahwa kami menggunakan tanda bintang ( *<\/strong> ) di sekitar substring untuk menunjukkan bahwa karakter apa pun dapat muncul sebelum atau sesudah string “panas” di dalam sel.<\/span><\/p>\n
 Jika kita ingin memeriksa apakah setiap string dimulai dengan<\/strong> “panas”, kita dapat menempatkan tanda bintang hanya setelah substring:<\/span><\/p>\n
 SubCheckLike<\/span> ()\n\nDim<\/span> i As<\/span> Integer\n    \nFor<\/span> i = 2 To<\/span> 10\n    If<\/span> Range(\"A\" & i) Like<\/span> \"hot*\" Then<\/span>\n        Range(\"B\" & i) = \"Starts with hot\"\n    Else<\/span>\n        Range(\"B\" & i) = \"Does not start with hot\"\n    End If<\/span>\nNext<\/span> i\n    \nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kolom B menunjukkan apakah setiap sel yang cocok di kolom A dimulai dengan<\/strong> “panas” atau tidak.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya menggunakan VBA:<\/span><\/p>\n
 VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a>
 VBA: cara memeriksa apakah suatu string berisi string lain<\/a>
 VBA: Cara menghitung sel dengan teks tertentu<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan operator Suka di VBA untuk menentukan apakah suatu string berisi pola tertentu. Misalnya, Anda dapat menggunakan sintaks berikut untuk memeriksa apakah setiap string dalam rentang sel A2:A10 berisi substring “panas” dan menampilkan hasilnya dalam rentang B2:B10 : SubCheckLike () Dim i As Integer For i = 2 To 10 If Range(“A” & […]<\/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":"\nCara Menggunakan Operator Like di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa 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\/suka-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Operator Like di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/suka-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T17:12:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wv1.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\/suka-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/suka-vba\/\",\"name\":\"Cara Menggunakan Operator Like di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T17:12:29+00:00\",\"dateModified\":\"2023-07-05T17:12:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/suka-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/suka-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/suka-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan operator like 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 Operator Like di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa 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\/suka-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Operator Like di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/suka-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-05T17:12:29+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/wv1.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\/suka-vba\/","url":"https:\/\/statorials.org\/id\/suka-vba\/","name":"Cara Menggunakan Operator Like di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T17:12:29+00:00","dateModified":"2023-07-05T17:12:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator Suka di VBA untuk memeriksa apakah sel berisi substring tertentu, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/suka-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/suka-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/suka-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan operator like 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\/4973"}],"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=4973"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4973\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}