{"id":4425,"date":"2023-07-11T05:18:08","date_gmt":"2023-07-11T05:18:08","guid":{"rendered":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/"},"modified":"2023-07-11T05:18:08","modified_gmt":"2023-07-11T05:18:08","slug":"sel-sorotan-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/","title":{"rendered":"Cara menyorot sel di vba: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut di VBA untuk menyorot sel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Sorot sel yang aktif<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightActiveCell<\/span> ()\nActiveCell.Interior.Color = vbYellow\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menyorot sel yang sedang aktif dengan latar belakang kuning.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Sorot Rentang Sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightRange<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">B2:B10<\/span> \").Interior.Color = vbYellow\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menyorot setiap sel dalam rentang <strong>B2:B10<\/strong> dengan latar belakang kuning.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Sorot rentang sel berdasarkan kriteria<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightRangeBasedOnCriteria<\/span> ()\n\n  <span style=\"color: #0000ff;\">Dim<\/span> rng <span style=\"color: #0000ff;\">As<\/span> Range\n  \n  <span style=\"color: #0000ff;\">For Each<\/span> rng <span style=\"color: #0000ff;\">In<\/span> Range(\" <span style=\"color: #ff0000;\">B2:B10<\/span> \")\n  \n      <span style=\"color: #0000ff;\">If<\/span> rng.Value &gt; 20 <span style=\"color: #0000ff;\">Then<\/span>\n        rng.Interior.Color = vbYellow\n      <span style=\"color: #0000ff;\">End If<\/span>\n      \n  <span style=\"color: #0000ff;\">Next<\/span> rng\n  \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menyorot setiap sel dalam rentang <strong>B2:B10<\/strong> yang memiliki nilai lebih besar dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34678 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euh1.jpg\" alt=\"\" width=\"498\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Sorot sel yang aktif<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Asumsikan sel <strong>B3<\/strong> saat ini dipilih.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menyorot sel aktif ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightActiveCell<\/span> ()\nActiveCell.Interior.Color = vbYellow\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-34683\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ha1.jpg\" alt=\"VBA menyoroti sel aktif\" width=\"488\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>B3<\/strong> disorot dan semua sel lainnya tetap tidak tersentuh.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Sorot Rentang Sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel dalam rentang <strong>B2:B10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightRange<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">B2:B10<\/span> \").Interior.Color = vbYellow\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34684\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ha2.jpg\" alt=\"VBA menyoroti rentang sel\" width=\"505\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap sel dalam rentang <strong>B2:B10<\/strong> disorot dan semua sel lainnya tetap tidak tersentuh.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Sorot rentang sel berdasarkan kriteria<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menyorot setiap sel dalam rentang <strong>B2:B10<\/strong> yang memiliki nilai lebih besar dari 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubHighlightRangeBasedOnCriteria<\/span> ()\n\n  <span style=\"color: #0000ff;\">Dim<\/span> rng <span style=\"color: #0000ff;\">As<\/span> Range\n  \n  <span style=\"color: #0000ff;\">For Each<\/span> rng <span style=\"color: #0000ff;\">In<\/span> Range(\" <span style=\"color: #ff0000;\">B2:B10<\/span> \")\n  \n      <span style=\"color: #0000ff;\">If<\/span> rng.Value &gt; 20 <span style=\"color: #0000ff;\">Then<\/span>\n        rng.Interior.Color = vbYellow\n      <span style=\"color: #0000ff;\">End If<\/span>\n      \n  <span style=\"color: #0000ff;\">Next<\/span> rng\n  \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-34685\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ha3.jpg\" alt=\"VBA menyoroti sel berdasarkan kriteria\" width=\"499\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap sel dalam rentang <strong>B2:B10<\/strong> dengan nilai lebih besar dari 20 disorot dan semua sel lainnya tetap tidak tersentuh.<\/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\/pemformatan-bersyarat-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menerapkan pemformatan bersyarat ke sel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-memformat-nilai-duplikat-bersyarat\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menerapkan pemformatan bersyarat ke nilai duplikat<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pencarian-vba-di-kolom\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mencari nilai dalam kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut di VBA untuk menyorot sel: Metode 1: Sorot sel yang aktif SubHighlightActiveCell () ActiveCell.Interior.Color = vbYellow End Sub Makro khusus ini akan menyorot sel yang sedang aktif dengan latar belakang kuning. Metode 2: Sorot Rentang Sel SubHighlightRange () Range(&#8221; B2:B10 &#8220;).Interior.Color = vbYellow End Sub Makro khusus ini akan menyorot [&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 Menyorot Sel di VBA (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, 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\/sel-sorotan-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menyorot Sel di VBA (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sel-sorotan-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T05:18:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euh1.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\/sel-sorotan-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/sel-sorotan-vba\/\",\"name\":\"Cara Menyorot Sel di VBA (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T05:18:08+00:00\",\"dateModified\":\"2023-07-11T05:18:08+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sel-sorotan-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sel-sorotan-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sel-sorotan-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyorot sel 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 Menyorot Sel di VBA (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, 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\/sel-sorotan-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menyorot Sel di VBA (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T05:18:08+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euh1.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\/sel-sorotan-vba\/","url":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/","name":"Cara Menyorot Sel di VBA (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T05:18:08+00:00","dateModified":"2023-07-11T05:18:08+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyorot sel di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sel-sorotan-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sel-sorotan-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyorot sel 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\/4425"}],"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=4425"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4425\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}