{"id":4467,"date":"2023-07-10T21:20:46","date_gmt":"2023-07-10T21:20:46","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/"},"modified":"2023-07-10T21:20:46","modified_gmt":"2023-07-10T21:20:46","slug":"vba-membandingkan-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/","title":{"rendered":"Cara membandingkan string di vba: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut di VBA untuk membandingkan string:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Membandingkan string peka huruf besar-kecil<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCompareStrings<\/span> ()\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> 10\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = StrComp(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i)) = 0\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;\">Makro ini akan melakukan perbandingan string peka huruf besar-kecil antara string dalam sel yang cocok dalam rentang <strong>A2:A10<\/strong> dan <strong>B2:B10<\/strong> dan mengembalikan TRUE atau FALSE dalam rentang <strong>C2:C10<\/strong> untuk menunjukkan apakah string tersebut sama atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Perbandingan string yang tidak peka huruf besar-kecil<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCompareStrings<\/span> ()\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> 10\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = StrComp(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i), vbTextCompare) = 0\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;\">Makro ini akan melakukan perbandingan string yang tidak peka huruf besar-kecil antara string dalam sel yang cocok dalam rentang <strong>A2:A10<\/strong> dan <strong>B2:B10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan daftar string berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34969 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/str1.png\" alt=\"\" width=\"476\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Membandingkan String Peka Huruf Besar-kecil di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan perbandingan string peka huruf besar-kecil antara setiap string yang cocok di kolom A dan B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCompareStrings<\/span> ()\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> 10\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = StrComp(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i)) = 0\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=\"aligncenter wp-image-34970\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/str2.png\" alt=\"membandingkan string peka huruf besar-kecil di VBA\" width=\"477\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C mengembalikan <strong>TRUE<\/strong> jika stringnya sama dan memiliki huruf besar\/kecil yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, kolom C akan mengembalikan <strong>FALSE<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Membandingkan String Tidak Peka Huruf Besar-kecil di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan perbandingan string yang tidak peka huruf besar-kecil antara setiap string yang cocok di kolom A dan B:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCompareStrings<\/span> ()\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> 10\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = StrComp(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i), Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i), vbTextCompare) = 0\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=\"aligncenter wp-image-34971\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/str3.png\" alt=\"perbandingan string tidak peka huruf besar-kecil di VBA\" width=\"499\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C mengembalikan <strong>TRUE<\/strong> jika stringnya sama, apa pun hurufnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom C mengembalikan <strong>FALSE<\/strong> hanya jika stringnya tidak sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>StrComp<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/strcomp-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-mengganti-karakter-dalam-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengganti karakter dalam sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghapus-karakter-khusus-dari-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghapus karakter khusus dari sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengubah string menjadi int<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut di VBA untuk membandingkan string: Metode 1: Membandingkan string peka huruf besar-kecil SubCompareStrings () Dim i As Integer For i = 2 To 10 Range(&#8221; C &#8221; &amp; i) = StrComp(Range(&#8221; A &#8221; &amp; i), Range(&#8221; B &#8221; &amp; i)) = 0 Next i End Sub Makro ini akan melakukan [&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>Cara Membandingkan String di VBA (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.\" \/>\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-membandingkan-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membandingkan String di VBA (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-membandingkan-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T21:20:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/str1.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-membandingkan-string\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-membandingkan-string\/\",\"name\":\"Cara Membandingkan String di VBA (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T21:20:46+00:00\",\"dateModified\":\"2023-07-10T21:20:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-membandingkan-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-membandingkan-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-membandingkan-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membandingkan string 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 Membandingkan String di VBA (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.","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-membandingkan-string\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membandingkan String di VBA (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/","og_site_name":"Statorials","article_published_time":"2023-07-10T21:20:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/str1.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-membandingkan-string\/","url":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/","name":"Cara Membandingkan String di VBA (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T21:20:46+00:00","dateModified":"2023-07-10T21:20:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membandingkan string menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-membandingkan-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-membandingkan-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membandingkan string 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\/4467"}],"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=4467"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4467\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}