{"id":4374,"date":"2023-07-11T14:50:04","date_gmt":"2023-07-11T14:50:04","guid":{"rendered":"https:\/\/statorials.org\/id\/mod-vba\/"},"modified":"2023-07-11T14:50:04","modified_gmt":"2023-07-11T14:50:04","slug":"mod-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mod-vba\/","title":{"rendered":"Cara menggunakan operator mod di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <strong>Mod<\/strong> di VBA untuk menghitung sisa pembagian.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut dua cara umum untuk menggunakan operator ini dalam praktiknya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan Operator Mod dengan Nilai Hardcoded<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubUseMod<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \") = 20 Mod 6\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan mengembalikan sisa 20 dibagi 6 di sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan operator Mod dengan referensi sel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubUseMod<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">C2<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A2<\/span> \") Mod Range(\" <span style=\"color: #ff0000;\">B2<\/span> \")\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan menghitung sisa nilai di sel <strong>A2<\/strong> dibagi dengan nilai di sel <strong>B2<\/strong> dan menampilkan hasilnya di sel <strong>C2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan Operator Mod dengan Nilai Hardcoded<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung sisa 20 dibagi 6 dan menampilkan hasilnya di sel <strong>A1<\/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;\">SubUseMod<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \") = 20 Mod 6\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-34334 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod11.jpg\" alt=\"\" width=\"493\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasil dari 20 putaran Mod 6 adalah <strong>2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai ini ditampilkan di sel <strong>A1<\/strong> , seperti yang kita tentukan di makro.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Nilai &#8220;6&#8221; dimasukkan ke &#8220;20&#8221; sebanyak tiga kali dan mempunyai sisa <strong>2<\/strong> . Beginilah cara 20 Mod 6 dihitung.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Menggunakan Operator Mod dengan Referensi Sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung sisa nilai di sel <strong>A2<\/strong> dibagi dengan nilai di sel <strong>B2<\/strong> dan menampilkan hasilnya di sel <strong>C2<\/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;\">SubUseMod<\/span> ()\nRange(\" <span style=\"color: #ff0000;\">C2<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A2<\/span> \") Mod Range(\" <span style=\"color: #ff0000;\">B2<\/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-34335 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod12.jpg\" alt=\"\" width=\"514\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasil dari 20 putaran Mod 6 adalah <strong>2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai ini ditampilkan di sel <strong>C2<\/strong> , seperti yang kita tentukan di makro.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operator VBA <b>Mod<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/dotnet\/visual-basic\/language-reference\/operators\/mod-operator\" 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\/rentang-jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menambahkan nilai dalam suatu rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jarak-menengah\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai rata-rata rentang<\/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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator Mod di VBA untuk menghitung sisa pembagian. Berikut dua cara umum untuk menggunakan operator ini dalam praktiknya. Metode 1: Gunakan Operator Mod dengan Nilai Hardcoded SubUseMod () Range(&#8221; A1 &#8220;) = 20 Mod 6 End Sub Contoh khusus ini akan mengembalikan sisa 20 dibagi 6 di sel A1 . Metode 2: [&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 Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator MOD di 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\/mod-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator MOD di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mod-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T14:50:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod11.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/mod-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/mod-vba\/\",\"name\":\"Cara Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T14:50:04+00:00\",\"dateModified\":\"2023-07-11T14:50:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator MOD di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mod-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mod-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mod-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan operator mod 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 Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan operator MOD di 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\/mod-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan operator MOD di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/mod-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T14:50:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mod11.jpg"}],"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\/mod-vba\/","url":"https:\/\/statorials.org\/id\/mod-vba\/","name":"Cara Menggunakan Operator MOD di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T14:50:04+00:00","dateModified":"2023-07-11T14:50:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator MOD di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mod-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mod-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mod-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan operator mod 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\/4374"}],"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=4374"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4374\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}