{"id":2214,"date":"2023-09-01T07:09:32","date_gmt":"2023-09-01T07:09:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/modul\/"},"modified":"2023-12-06T06:18:39","modified_gmt":"2023-12-06T06:18:39","slug":"modul","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/modul\/","title":{"rendered":"Bagaimana cara menggunakan modul vba di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2891324234\"><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> <h2 class=\"wp-block-heading\">Apa itu modul VBA<\/h2><p> Modul VBA adalah file berekstensi &#8220;.bcf&#8221; yang berisi kode dalam <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">editor Visual Basic<\/a> . Setiap modul memiliki jendela kodenya sendiri tempat Anda dapat menulis. Anda dapat memasukkan modul baru, menghapusnya, menyimpannya dan mengimpornya. Secara sederhana, ini seperti file teks yang Anda buka di Notepad.<\/p><p> Dalam tutorial ini, kita akan mempelajari segala sesuatu tentang penggunaan modul di VBA.<\/p><h2 class=\"wp-block-heading\"> Masukkan modul VBA<\/h2><ol type=\"1\"><li> Pertama, buka jendela proyek jika belum ada.<\/li><li> Selanjutnya, klik kanan pada proyek ( <a href=\"https:\/\/exceladvisor.org\/id\/bahan-pengikat\/\">file Excel<\/a> ) yang ingin Anda sisipkan modul.<\/li><li> Setelah itu, buka Sisipkan dan klik \u201cModul\u201d.<\/li><li> Setelah Anda melakukannya, Anda akan langsung mendapatkan modul baru dan dapat membuka jendela kodenya untuk menulis kode. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55674\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"masukkan ke modul vba\" width=\"543\" height=\"414\"><\/figure><\/div><p> Anda juga dapat masuk ke menu sisipkan lalu pada modul untuk memasukkannya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55675\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inserer-menu-puis-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"536\" height=\"368\"><\/figure><\/div><p> Saat Anda memasukkan modul baru, VBA membuat folder terpisah untuk semua modul yang Anda miliki di proyek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55676\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-cree-un-dossier-separe.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"512\" height=\"406\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hapus modul VBA<\/h2><ol type=\"1\"><li> Klik pada proyek yang modulnya ingin Anda hapus.<\/li><li> Sekarang, klik kanan pada modul yang ingin Anda hapus dan klik \u201cHapus\u201d.<\/li><li> Setelah itu, Anda perlu mengonfirmasi apakah Anda ingin menyimpan modul sebelum menghapusnya.<\/li><li> Pada akhirnya, klik &#8220;Ya&#8221; untuk menghapusnya. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55677\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-un-module-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"505\" height=\"540\"><\/figure><\/div><p> Ada satu hal yang perlu Anda ketahui di sini ketika Anda mengklik opsi hapus, ia meminta Anda untuk membuat cadangan modul Anda sebelum menghapusnya (jika Anda mau). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55678\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-sauvegarder-votre-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"405\" height=\"189\"><\/figure><\/div><p> Ini adalah cara cerdas untuk mengingatkan Anda untuk mendapatkan cadangan modul.<\/p><h2 class=\"wp-block-heading\"> Ekspor dan impor modul VBA<\/h2><p> Anda juga dapat mengimpor dan mengekspor modul dari satu file Excel ke file lainnya alih-alih menyalin dan menempelkan kode. Ini adalah salah satu cara terbaik untuk membagikan kode Anda kepada orang lain. Saat Anda mengklik kanan pada sebuah modul, Anda memiliki kedua opsi di sana. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55679\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-exporter-et-importer-un-module-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"420\" height=\"420\"><\/figure><\/div><p> Seperti yang saya katakan sebelumnya, Anda dapat menyimpan modul sebagai file \u201c.bcf\u201d dan mengimpornya nanti atau ke file Excel lain.<\/p><p class=\"qt-tip\"> <strong>Tip:<\/strong> Jika Anda ingin menyalin seluruh modul ke proyek lain yang file Excelnya terbuka saat itu. Seret dan lepas modul ini ke proyek tempat Anda ingin menyalinnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55680\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-glisser-deposer-un-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"473\" height=\"405\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Modul VBA Normal Vs Modul Kelas<\/h2><p> Saat Anda memasukkan modul baru, Anda mungkin melihat opsi untuk memasukkan modul kelas. Namun ada sedikit perbedaan antara kedua modul tersebut. <strong>Seperti yang telah Anda pahami segala sesuatu tentang modul standar, modul kelas adalah modul khusus yang dapat membantu Anda membuat objek khusus.<\/strong> Anda juga dapat menentukan metode, properti, dan kejadian untuk objek ini. Dan saat Anda membuat objek baru dari modul kelas, Anda juga bisa merujuknya dari modul standar.<\/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\/pertanyaan-wawancara\/\">Pertanyaan Wawancara VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/komentar\/\">Tambahkan komentar dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jeda-baris\/\">Tambahkan jeda baris dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-baru\/\">Tambahkan baris baru (carriage return) dalam string di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan Makro di Excel (Jalankan Kode 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-2214","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>Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan<\/title>\n<meta name=\"description\" content=\"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri\" \/>\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\/modul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan\" \/>\n<meta property=\"og:description\" content=\"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/modul\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/modul\/\",\"name\":\"Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png\",\"datePublished\":\"2023-09-01T07:09:32+00:00\",\"dateModified\":\"2023-12-06T06:18:39+00:00\",\"description\":\"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/modul\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/modul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan modul vba di excel?\"}]},{\"@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":"Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan","description":"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri","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\/modul\/","og_locale":"id_ID","og_type":"article","og_title":"Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan","og_description":"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri","og_url":"https:\/\/exceladvisor.org\/id\/modul\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/modul\/","url":"https:\/\/exceladvisor.org\/id\/modul\/","name":"Modul VBA | Sisipkan, Hapus, Pulihkan, dan Cadangkan","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png","datePublished":"2023-09-01T07:09:32+00:00","dateModified":"2023-12-06T06:18:39+00:00","description":"Modul VBA adalah file berekstensi &quot;.bcf&quot; yang berisi kode dalam editor Visual Basic. Setiap modul memiliki jendelanya sendiri","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/modul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/modul\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/modul\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-un-module-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/modul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan modul vba di excel?"}]},{"@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\/2214","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=2214"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2214\/revisions"}],"predecessor-version":[{"id":2751,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2214\/revisions\/2751"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}