{"id":2151,"date":"2023-09-28T21:29:23","date_gmt":"2023-09-28T21:29:23","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/modus-1\/"},"modified":"2023-12-06T06:18:38","modified_gmt":"2023-12-06T06:18:38","slug":"modus-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/modus-1\/","title":{"rendered":"Bagaimana cara menggunakan mod di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3587436458\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di VBA, MOD adalah operator, bukan fungsi dan operator ini membantu Anda membagi dua angka dan mengembalikan nilai sisanya pada hasilnya.<\/p><p> Ini setara dengan fungsi mod Excel.<\/p><p> Anda dapat menggunakan mod dengan banyak cara dan dalam tutorial ini kita akan melihat beberapa contoh. Ikuti langkah-langkah di bawah ini untuk menggunakan operator mod di VBA:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = 10 Mod 3<\/code><\/pre><ol type=\"1\"><li> Tentukan angka pertama yang ingin Anda bagi.<\/li><li> Setelah itu masukkan operator \u201cmod\u201d.<\/li><li> Sekarang masukkan angka yang ingin Anda bagi.<\/li><li> Pada akhirnya gunakan kotak pesan atau sel untuk mendapatkan sisa pembagian. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62196\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"mod-in-vba\" width=\"455\" height=\"378\"><\/figure><\/div><p> Demikian pula, Anda juga bisa mendapatkan sisanya menggunakan kotak pesan.<\/p><p> Dan pada kode berikut kami menggunakan kotak pesan dan kemudian menggunakan operator mod untuk mendapatkan sisanya setelah pembagian.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox 9 Mod 3<\/code><\/pre><p> Dan ketika Anda menjalankan kode ini, ia mengembalikan hasil nol di kotak pesan karena ketika Anda membagi 9 dengan 3 tidak ada sisa yang tersisa, begitu pula dengan hasil kode ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62197\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boites-de-message.png\" sizes=\"auto, \" srcset=\"\" alt=\"pesan\" width=\"168\" height=\"199\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Seperti yang saya katakan, di Excel juga ada fungsi untuk mendapatkan sisa pembagian dua angka dan ada beberapa situasi di mana Anda akan menemukan bahwa hasil yang Anda dapatkan dari Excel akan berbeda dengan hasil yang Anda dapatkan di VBA.<\/p><h2 class=\"wp-block-heading\"> Kesalahan dalam MOD<\/h2><p> Jika Anda mencoba membagi suatu angka dengan nol, hasilnya selalu berupa kesalahan pembagian dengan nol.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Debug.Print 10 Mod 0<\/code><\/pre><p> Dan kode di atas memunculkan kesalahan ini.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/rata-rata-2\/\">Nilai rata-rata di Excel dengan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-hari-ini-waktu-saat-ini\/\">Dapatkan tanggal hari ini dan waktu saat ini menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-1\/\">Jumlahkan nilai di Excel menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pertandingan-2\/\">Fungsi kecocokan di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\">Fungsi lembar kerja VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2151","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/modus-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/modus-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/modus-1\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png\",\"datePublished\":\"2023-09-28T21:29:23+00:00\",\"dateModified\":\"2023-12-06T06:18:38+00:00\",\"description\":\"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/modus-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modus-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan mod di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)","description":"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini","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:\/\/exceladvisor.org\/id\/modus-1\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)","og_description":"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini","og_url":"https:\/\/exceladvisor.org\/id\/modus-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/modus-1\/","url":"https:\/\/exceladvisor.org\/id\/modus-1\/","name":"\u25b7 Bagaimana cara menggunakan MOD di VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png","datePublished":"2023-09-28T21:29:23+00:00","dateModified":"2023-12-06T06:18:38+00:00","description":"Dalam tutorial VBA ini, kita akan mempelajari cara menggunakan MOD dalam sebuah kode. Anda dapat menggunakannya dalam banyak cara dan dalam tutorial ini","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/modus-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/modus-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/modus-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-module-en-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/modus-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan mod di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2151"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2151\/revisions"}],"predecessor-version":[{"id":2749,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2151\/revisions\/2749"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}