{"id":4496,"date":"2023-07-10T15:34:18","date_gmt":"2023-07-10T15:34:18","guid":{"rendered":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/"},"modified":"2023-07-10T15:34:18","modified_gmt":"2023-07-10T15:34:18","slug":"tanggal-pertandingan-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/","title":{"rendered":"Vba: cara menggunakan fungsi match dengan tanggal"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi MATCH untuk menemukan tanggal di VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubMatchDate<\/span> ()\n    \n<span style=\"color: #008000;\">'attempt to find date in range\n<\/span><span style=\"color: #0000ff;\">On Error GoTo<\/span> NoMatch\n    MyMatch = WorksheetFunction.Match(CLng(CDate(\" <span style=\"color: #ff0000;\">4\/15\/2023<\/span> \")), Range(\" <span style=\"color: #ff0000;\">A2:A10<\/span> \"), 0)\n    MsgBox (MyMatch)\n<span style=\"color: #0000ff;\">End<\/span>\n    \n<span style=\"color: #008000;\">'if no date found, create message box to tell user\n<\/span><span style=\"color: #0000ff;\">NoMatch:<\/span>\n    MsgBox (\" <span style=\"color: #ff0000;\">No Match Found<\/span> \")\n<span style=\"color: #0000ff;\">End<\/span>\n\n<span style=\"color: #0000ff;\">End:<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mencari tanggal <strong>15\/04\/2023<\/strong> dalam rentang <strong>A2:A10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tanggal ditemukan, kotak pesan akan muncul memberitahu pengguna baris mana dalam rentang yang berisi tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tanggal tidak ditemukan, kotak pesan muncul mengatakan &#8220;Tidak ditemukan kecocokan&#8221; sehingga pengguna mengetahui tanggal tidak ada dalam rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>CDate<\/strong> mengubah string teks menjadi tanggal di VBA.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggunakan Fungsi MATCH dengan Tanggal di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar tanggal berikut dalam rentang <strong>A2:A10<\/strong> di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35163 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mdate1.png\" alt=\"\" width=\"448\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menemukan nomor baris yang berisi tanggal <strong>15\/04\/2023<\/strong> dalam rentang <strong>A2:A10<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubMatchDate<\/span> ()\n    \n<span style=\"color: #008000;\">'attempt to find date in range\n<\/span><span style=\"color: #0000ff;\">On Error GoTo<\/span> NoMatch\n    MyMatch = WorksheetFunction.Match(CLng(CDate(\" <span style=\"color: #ff0000;\">4\/15\/2023<\/span> \")), Range(\" <span style=\"color: #ff0000;\">A2:A10<\/span> \"), 0)\n    MsgBox (MyMatch)\n<span style=\"color: #0000ff;\">End<\/span>\n    \n<span style=\"color: #008000;\">'if no date found, create message box to tell user\n<\/span><span style=\"color: #0000ff;\">NoMatch:<\/span>\n    MsgBox (\" <span style=\"color: #ff0000;\">No Match Found<\/span> \")\n<span style=\"color: #0000ff;\">End<\/span>\n\n<span style=\"color: #0000ff;\">End:<\/span>\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=\" wp-image-35164 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mdate2.png\" alt=\"\" width=\"506\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan memberi tahu kita bahwa tanggal <strong>15\/04\/2023<\/strong> ditemukan di baris <strong>ke-7<\/strong> rentang <strong>A2:A10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita mencari tanggal <strong>25\/04\/2023<\/strong> , kita akan menerima hasil berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35165 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mdate3.png\" alt=\"\" width=\"470\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan memberi tahu kita bahwa tanggal <strong>25\/04\/2023<\/strong> tidak ditemukan dalam rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap metode <strong>Match<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheetfunction.match\" 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-xlookup\/\" target=\"_blank\" rel=\"noopener\">VBA: cara menggunakan XLOOKUP<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pencocokan-indeks-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan pencocokan indeks<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/indeks-vba-beberapa-kriteria-kecocokan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan INDEX MATCH dengan berbagai kriteria<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi MATCH untuk menemukan tanggal di VBA: SubMatchDate () &#8216;attempt to find date in range On Error GoTo NoMatch MyMatch = WorksheetFunction.Match(CLng(CDate(&#8221; 4\/15\/2023 &#8220;)), Range(&#8221; A2:A10 &#8220;), 0) MsgBox (MyMatch) End &#8216;if no date found, create message box to tell user NoMatch: MsgBox (&#8221; No Match Found &#8220;) [&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 menggunakan fungsi MATCH dengan tanggal - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, 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\/tanggal-pertandingan-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menggunakan fungsi MATCH dengan tanggal - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T15:34:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mdate1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/\",\"name\":\"VBA: Cara menggunakan fungsi MATCH dengan tanggal - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T15:34:18+00:00\",\"dateModified\":\"2023-07-10T15:34:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menggunakan fungsi match dengan tanggal\"}]},{\"@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 menggunakan fungsi MATCH dengan tanggal - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, 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\/tanggal-pertandingan-vba\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menggunakan fungsi MATCH dengan tanggal - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-10T15:34:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mdate1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/","url":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/","name":"VBA: Cara menggunakan fungsi MATCH dengan tanggal - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T15:34:18+00:00","dateModified":"2023-07-10T15:34:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi MATCH di VBA untuk mencocokkan tanggal, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tanggal-pertandingan-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menggunakan fungsi match dengan tanggal"}]},{"@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\/4496"}],"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=4496"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4496\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}