{"id":4423,"date":"2023-07-11T05:34:20","date_gmt":"2023-07-11T05:34:20","guid":{"rendered":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/"},"modified":"2023-07-11T05:34:20","modified_gmt":"2023-07-11T05:34:20","slug":"pencarian-vba-di-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/","title":{"rendered":"Vba: cara menemukan nilai dalam kolom (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut di VBA untuk menemukan nilai dalam kolom di Excel:<\/span><\/p>\n

 Sub<\/span> FindValue()\n\nDim<\/span> rng As<\/span> Range\nDim<\/span> cell As<\/span> Range\nDim<\/span> findString As<\/span> String\n\n'specify range to look in<\/span>\nSet<\/span> rng = ActiveSheet.Columns(\" A:A<\/span> \")\n\n'specify string to look for<\/span>\nfindString = \" Rockets<\/span> \"\n\n'find cell with string<\/span>\nSet<\/span> cell = rng.Find(What:=findString, LookIn:=xlFormulas, _\n                    LookAt:=xlWhole, MatchCase:=False)\n\nIf<\/span> cell Is Nothing Then<\/span>\n    cell.Font.Color = vbBlack\nElse<\/span>\n    cell.Font.Color = vbRed\n    cell.Font.Bold = True\nEnd If<\/span>\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan mencari seluruh kolom A dari lembar yang sedang aktif untuk string “Rockets” dan, jika ditemukan, mengubah warna font sel menjadi merah dan membuat font menjadi tebal.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara Mencari Nilai pada Kolom Menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin mencari nama tim “Rockets” di kolom A, dan setelah ditemukan, ubah warna font sel menjadi merah dan buat font menjadi tebal.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> FindValues()\n\nDim<\/span> rng As<\/span> Range\nDim<\/span> cell As<\/span> Range\nDim<\/span> findString As<\/span> String\n\n'specify range to look in<\/span>\nSet<\/span> rng = ActiveSheet.Columns(\" A:A<\/span> \")\n\n'specify string to look for<\/span>\nfindString = \" Rockets<\/span> \"\n\n'find cell with string<\/span>\nSet<\/span> cell = rng.Find(What:=findString, LookIn:=xlFormulas, _\n                    LookAt:=xlWhole, MatchCase:=False)\n\nIf<\/span> cell Is Nothing Then<\/span>\n    cell.Font.Color = vbBlack\nElse<\/span>\n    cell.Font.Color = vbRed\n    cell.Font.Bold = True\nEnd If<\/span>\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa font di sel yang berisi string “Rockets” sekarang berwarna merah dan tebal.<\/span><\/p>\n
 Semua sel lainnya hanya menyimpan font hitamnya.<\/span><\/p>\n
 Perhatikan bahwa argumen MatchCase:=False<\/strong> dalam kode memberitahu VBA untuk melakukan pencarian peka huruf besar\/kecil.<\/span><\/p>\n
 Jadi jika nama tim di kolom A adalah “roket”, makro akan selalu menemukan string tersebut dan membuat font menjadi merah dan tebal.<\/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 menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a>
 VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a>
 VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut di VBA untuk menemukan nilai dalam kolom di Excel: Sub FindValue() Dim rng As Range Dim cell As Range Dim findString As String ‘specify range to look in Set rng = ActiveSheet.Columns(” A:A “) ‘specify string to look for findString = ” Rockets ” ‘find cell with string Set […]<\/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: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel 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\/pencarian-vba-di-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T05:34:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouverval1.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\/pencarian-vba-di-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/\",\"name\":\"VBA: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T05:34:20+00:00\",\"dateModified\":\"2023-07-11T05:34:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menemukan nilai dalam kolom (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":"VBA: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial","description":"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel 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\/pencarian-vba-di-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-11T05:34:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouverval1.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\/pencarian-vba-di-kolom\/","url":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/","name":"VBA: Cara menemukan nilai dalam kolom (dengan contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T05:34:20+00:00","dateModified":"2023-07-11T05:34:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari nilai pada kolom di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menemukan nilai dalam kolom (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\/4423"}],"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=4423"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4423\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}