{"id":4057,"date":"2023-07-13T21:35:49","date_gmt":"2023-07-13T21:35:49","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-berisi-string\/"},"modified":"2023-07-13T21:35:49","modified_gmt":"2023-07-13T21:35:49","slug":"vba-berisi-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-berisi-string\/","title":{"rendered":"Vba: cara memeriksa apakah suatu string berisi string lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>Instr()<\/strong> di VBA untuk memeriksa apakah suatu string berisi string lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Instr(mulai, string1, string2, \u2026)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>start<\/strong> : Posisi awal pencarian<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>string1<\/strong> : String yang akan dicari<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>string2<\/strong> : string yang Anda coba temukan<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan VBA untuk memeriksa apakah string berisi string lain<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32366 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherche1.png\" alt=\"\" width=\"478\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin memeriksa apakah setiap string di kolom Tim berisi &#8220;avs&#8221; di suatu tempat di string tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut di VBA untuk memeriksa apakah setiap string di kolom Tim berisi &#8220;avs&#8221; dan, jika demikian, kembalikan seluruh baris di kolom D dan E:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> <span style=\"color: #000000;\">StringContains()<\/span>\n<span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> <span style=\"color: #0000ff;\">Integer<\/span> , i_num <span style=\"color: #0000ff;\">As<\/span> <span style=\"color: #0000ff;\">Integer<\/span>\n\n<span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 9\n    <span style=\"color: #0000ff;\">If<\/span> InStr(1, LCase(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" <span style=\"color: #0000ff;\">&amp;<\/span> i)), \" <span style=\"color: #ff0000;\">avs<\/span> \") &lt;&gt; 0 <span style=\"color: #0000ff;\">Then<\/span>\n        i_num = i_num + 1\n        Range(\" <span style=\"color: #ff0000;\">D<\/span> \" <span style=\"color: #0000ff;\">&amp;<\/span> i_num <span style=\"color: #0000ff;\">&amp;<\/span> \" <span style=\"color: #ff0000;\">:E<\/span> \" <span style=\"color: #0000ff;\">&amp;<\/span> i_num) = Range(\" <span style=\"color: #ff0000;\">A<\/span> \" <span style=\"color: #0000ff;\">&amp;<\/span> i <span style=\"color: #3366ff;\">&amp;<\/span> \" <span style=\"color: #ff0000;\">:B<\/span> \" <span style=\"color: #0000ff;\">&amp;<\/span> i).Value\n    <span style=\"color: #0000ff;\">End If<\/span>\n<span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/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-32367 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chaine1-1.png\" alt=\"\" width=\"488\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap baris yang berisi string &#8220;avs&#8221; di suatu tempat di kolom Tim dikembalikan di kolom D dan E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, hanya dua tim (Mavs dan Cavs) yang berisi &#8220;avs&#8221; di kolom Tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari string lain, cukup ganti &#8220;avs&#8221; pada kode di atas dengan string pilihan Anda.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1:<\/strong> Dalam kode, kami menggunakan <strong>For i = 2 hingga 9<\/strong> karena sel A2 hingga A9 berisi string yang kami minati. Jangan ragu untuk mengubah rentang ini tergantung pada rentang sel yang Anda cari.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>Instr()<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/instr-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 menggunakan 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-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai rata-rata rentang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi Instr() di VBA untuk memeriksa apakah suatu string berisi string lain. Fungsi ini menggunakan sintaks dasar berikut: Instr(mulai, string1, string2, \u2026) Emas: start : Posisi awal pencarian string1 : String yang akan dicari string2 : string yang Anda coba temukan Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Gunakan [&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 memeriksa apakah suatu string berisi string lain - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, 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-berisi-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara memeriksa apakah suatu string berisi string lain - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T21:35:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherche1.png\" \/>\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-berisi-string\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-berisi-string\/\",\"name\":\"VBA: Cara memeriksa apakah suatu string berisi string lain - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T21:35:49+00:00\",\"dateModified\":\"2023-07-13T21:35:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-berisi-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-berisi-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-berisi-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara memeriksa apakah suatu string berisi string lain\"}]},{\"@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 memeriksa apakah suatu string berisi string lain - Statorials","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, 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-berisi-string\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara memeriksa apakah suatu string berisi string lain - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-berisi-string\/","og_site_name":"Statorials","article_published_time":"2023-07-13T21:35:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/recherche1.png"}],"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-berisi-string\/","url":"https:\/\/statorials.org\/id\/vba-berisi-string\/","name":"VBA: Cara memeriksa apakah suatu string berisi string lain - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T21:35:49+00:00","dateModified":"2023-07-13T21:35:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VBA untuk memeriksa apakah suatu string berisi string lain, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-berisi-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-berisi-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-berisi-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara memeriksa apakah suatu string berisi string lain"}]},{"@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\/4057"}],"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=4057"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4057\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}