{"id":602,"date":"2021-03-04T10:29:18","date_gmt":"2021-03-04T02:29:18","guid":{"rendered":"https:\/\/indonesiangems.com\/blog\/?p=602"},"modified":"2021-03-19T06:27:56","modified_gmt":"2021-03-18T22:27:56","slug":"excel-userform-melalui-visual-basic-editor","status":"publish","type":"post","link":"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/","title":{"rendered":"Membuat Excel UserForm melalui Visual Basic Editor VBA"},"content":{"rendered":"<p class=\"last-updated\">Last updated on March 19th, 2021 at 06:27 am<\/p>\n<!--more-->\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link\" href=\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/\">ganti ke bahasa inggris<\/a><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Halaman ini adalah kelanjutan dari halaman sebelumnya, <a href=\"https:\/\/indonesiangems.com\/blog\/macro-untuk-form-input-di-excel\/\">&#8220;Membuat kode macro untuk form input di Excel (part-4)&#8221;<\/a>. Perbedaan antara form yang di topik sebelumnya (<a href=\"https:\/\/indonesiangems.com\/blog\/membuat-form-input-jual-beli-di-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">part-3<\/a>) dengan form di topik ini adalah : form di part-3 dibuat pada halaman Excel, sedangkan sekarang, form dibuat pada &#8220;canvas&#8221; khusus untuk form. Jadi sekarang pak Adi akan membuat <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/userform-window\" target=\"_blank\" rel=\"noreferrer noopener\">Excel UserForm<\/a> melalui Visual Basic editor (VBA).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Adapun kegunaan UserForm pada kasus pak Adi ini adalah untuk meng-input invoice invoice (nota nota jual\/beli) mana saja yang dibayarkan, baik oleh Piutang Dagang maupun oleh pak Adi sendiri.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Workflow nya disini sedikit berbelit belit, karena berdasarkan pengalaman pak Adi sendiri, beda customer beda kriteria cara mereka melakukan pembayaran-nya. Adapun model model pembayaran para customer-nya adalah sbb:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Tidak memperdulikan nomor nota (nomor invoice).<br>Pokok dibayar sekian, maka saldo hutang-nya tinggal sekian.<\/li><li>Memperdulikan nomor nota dan hutang di bulan tertentu.<br>Contoh : <em>&#8220;pak Adi, ini saya bayar nota nota bla, ble, blu bulan X ya&#8221;<\/em><\/li><li>Memperdulikan nomor nota tapi tidak perduli hutang di bulan apa.<br>Contoh : <em>&#8220;pak Adi, ini saya bayar nota yang minggu lalu ya, jadi nota nota hutang saya yang kemarin dan yang tiga bulan yang lalu belon saya bayarkan&#8221;<\/em>.<\/li><li>Mirip seperti dengan yang diatas.<br>Contoh : <em>&#8220;pak Adi, ini saya bayar nota nota bulan X sebagian dulu ya&#8221;<\/em><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Akibatnya ya pembuatan UserForm-nya sedikit berbelit belit agar UserForm bisa siap &#8220;bekerja&#8221; dalam menghadapi kriteria customer yang berbeda beda tsb dalam membayar hutang-nya.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><em>Mempersiapkan halaman halaman yang akan diperlukan untuk operasi UserForm<\/em><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Mirip dengan yang di <a href=\"https:\/\/indonesiangems.com\/blog\/membuat-form-input-jual-beli-di-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">halaman part-3<\/a>, hal pertama yang pak Adi lakukan adalah membuat halaman baru dan menamai-nya &#8220;BAYAR&#8221;. Selanjutnya mempersiapkan halaman &#8220;TABEL&#8221; agar ter-integrasi dengan UserForm-nya sewaktu di operasikan.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Mengetik rumus <code>=today()<\/code> pada cell C4 dan menamai beberapa cell seperti yang terlihat pada gambar-1 dibawah ini.<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-01_worksheet-payment.png\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"376\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-01_worksheet-payment.png\" alt=\"persiapan halaman untuk userform excel\" class=\"wp-image-1325\"\/><\/a><figcaption><em>gambar-1<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">2. Membuat dua buah Pivot Table di halaman TABEL. Cara membuat Pivot Table ini sama seperti di <a href=\"https:\/\/indonesiangems.com\/blog\/membuat-pivot-table-hutang-piutang-dan-stok-di-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">part-2<\/a>, yakni dengan mengkopi Pivot Table yang sudah ada, lalu paste di halaman yang memerlukan-nya. Selanjutnya mengatur kolom kolom yang diperlukan di Pivot Table, dan tidak lupa untuk menamai Pivot Table terkait.<\/p>\n\n\n<div class=\"contTxtOnP\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02a.png\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02a.png\"><\/a><p><\/p>\n<div class=\"TxtOnP\">Pivot table yang pertama pak Adi taruh di halaman &#8220;TABEL&#8221; cell H1.<br>Lalu dia menamakan Pivot Table ini : ptPDHDnonLunas<\/div>\n<\/div>\n<div class=\"contTxtOnP\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02b.png\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02b.png\"><\/a><p><\/p>\n<div class=\"TxtOnP\">\n<p>Masih di halaman &#8220;TABEL&#8221;, Pivot Table yang kedua pak Adi taruh di cell L1. <br>Lalu dia menamakan Pivot Table ini : ptBayar<\/p>\n<\/div>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><em>Membuat Excel UserForm melalui Visual Basic Editor<\/em><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Pada tab menu &#8220;Developer&#8221; bagian &#8220;Code&#8221;, klik &#8220;Visual Basic&#8221;. Seperti yang terlihat pada gambar-3 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-03_visual-basic-editor-menu-excel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"142\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-03_visual-basic-editor-menu-excel.png\" alt=\"letak-visual-basic-editor-pada-menu-excel\" class=\"wp-image-1359\"\/><\/a><figcaption><em>gambar-3<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Muncul window baru seperti pada gambar-4 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-04_Visual-Basic-Editor.png\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"545\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-04_Visual-Basic-Editor.png\" alt=\"tampilan-editor-pada-visual-basic-application\" class=\"wp-image-1360\"\/><\/a><figcaption><em>gambar-4<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Pada gambar-4 diatas, terlihat didalam window Microsoft Visual Basic for Applications (VBA) tsb, terdapat dua window di bagian kiri atas dan bawah, yakni window Project &#8211; VBAProject dan window Properties.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Klik kanan pada mouse (kanan ya, bukan kiri) di area window Project &#8211; VBAProject, pilih &#8220;Insert&#8221; lalu klik &#8220;UserForm&#8221;. Seperti yang terlihat pada gambar-5 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-05_create-userform.png\"><img loading=\"lazy\" decoding=\"async\" width=\"553\" height=\"523\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-05_create-userform.png\" alt=\"cara membuat excel userform melalui visual basic editor\" class=\"wp-image-1361\"\/><\/a><figcaption><em>gambar-5<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Muncul dua buah window baru, window &#8220;Toolbox&#8221; dan window UserForm berjudul &#8220;UserForm1&#8221;. Seperti yang terlihat pada gambar-6 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-06_blank-excel-user-form.png\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-06_blank-excel-user-form.png\" alt=\"blank excel userform di visual basic editor.\" class=\"wp-image-613\"\/><\/a><figcaption><em>gambar-6<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Pada window &#8220;Properties&#8221;, ganti nama-nya dari <em>UserForm1 <\/em>menjadi <em>frmBayar<\/em>. Ganti juga judul-nya (Caption) dari <em>UserForm1<\/em> menjadi <em>FORM BAYAR<\/em>. Seperti yang terlihat pada gambar-7 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"629\" height=\"186\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-07.png\" alt=\"\" class=\"wp-image-868\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Karena ada beberapa UserForm control yang diperlukan, pak Adi memperbesar &#8220;canvas&#8221; FORM BAYAR agar mudah meletakkan control control yang diperlukan. Cara memperbesar &#8220;canvas&#8221;-nya adalah dengan mengklik(kiri) kotak kecil di sudut kanan bawah UserForm, sambil terus menekan klik pada mouse, seret kebawah kotak kecil tsb sampai mencapai besar yang di-ingin-kan. Seperti yang terlihat pada animasi gambar-8 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-tw-border\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-08_resize-userform-canvas.gif\"><img loading=\"lazy\" decoding=\"async\" width=\"525\" height=\"452\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-08_resize-userform-canvas.gif\" alt=\"\" class=\"wp-image-1363\"\/><\/a><figcaption><em>gambar-8<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Pak Adi akan menempatkan control control yang terdapat di  window &#8220;Toolbox&#8221;. Ada lima jenis control yang diperlukan, yakni seperti yang terlihat pada gambar-9 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-09.png\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-09.png\" alt=\"\" class=\"wp-image-621\"\/><\/a><figcaption><em>gambar-9<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya cara menempatkan control controlnya di canvas UserForm, sama seperti di part-4, klik(kiri) kontrol yang di inginkan &#8211; lalu klik(kiri) di canvas-nya. Seperti yang terlihat pada animasi gambar-10 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-10_create-userform-controls.gif\"><img loading=\"lazy\" decoding=\"async\" width=\"466\" height=\"391\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-10_create-userform-controls.gif\" alt=\"\" class=\"wp-image-1364\"\/><\/a><figcaption><em>gambar-10<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">pak Adi membuat control control-nya sebanyak sbb:<\/p>\n\n\n\n<div style=\"max-width: 360px; margin: auto;\">\n<table class=\"MyTable\">\n<tr style=\"text-align: center;\">\n<th>CONTROL<\/th>\n<th style=\"text-align: center;\">JUMLAH<\/th>\n<\/tr>\n<tr>\n<td>Label<\/td>\n<td style=\"text-align: center;\">1<\/td>\n<\/tr>\n<tr>\n<td>TextBox<\/td>\n<td style=\"text-align: center;\">1<\/td>\n<\/tr>\n<tr>\n<td>ListBox<\/td>\n<td style=\"text-align: center;\">3<\/td>\n<\/tr>\n<tr>\n<td>Frame<\/td>\n<td style=\"text-align: center;\">2<\/td>\n<\/tr>\n<tr>\n<td>CommandButton<\/td>\n<td style=\"text-align: center;\">7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"--width:100%;flex-basis:100%\">\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-11.png\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-11.png\" alt=\"\" class=\"wp-image-711\"\/><\/a><figcaption><em>gambar-<\/em>11<\/figcaption><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Apabila kita klik salah satu control-nya, maka property-nya terlihat di window &#8220;Properties&#8221;, seperti yang terlihat di animasi gambar-12 dibawah ini.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-12.gif\"><img decoding=\"async\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-12.gif\" alt=\"\" class=\"wp-image-703\"\/><\/a><figcaption><em>gambar-12<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya pak Adi mengganti nama dan judul (caption) yang secara default sudah ada pada masing-masing controlnya di window &#8220;Properties&#8221; dengan cara seperti pada <a href=\"#gambar7\">gambar-7<\/a>. Nama dan judul\/caption-nya sebagai berikut :<\/p>\n\n\n\n<div style=\"max-width: 640px; margin: auto;\">\n<table class=\"MyTable\">\n<tr>\n<th>Control<\/th>\n<th>(Name)<\/th>\n<th>Caption<\/th>\n<\/tr>\n<tr>\n<td>Label1<\/td>\n<td>lblSum<\/td>\n<td>SUM<\/td>\n<\/tr>\n<tr>\n<td>TextBox1<\/td>\n<td>CARI<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox1<\/td>\n<td>ListNama<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox2<\/td>\n<td>ListBlnThn<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox3<\/td>\n<td>ListNota<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Frame1<\/td>\n<td>Frame1<\/td>\n<td>Pilih Nama PD\/HD<\/td>\n<\/tr>\n<tr>\n<td>Frame2<\/td>\n<td>Frame2<\/td>\n<td>Pindahkan Nota<\/td>\n<\/tr>\n<tr>\n<td>CommandButton1<\/td>\n<td>PD<\/td>\n<td>PD<\/td>\n<\/tr>\n<tr>\n<td>CommandButton2<\/td>\n<td>HD<\/td>\n<td>HD<\/td>\n<\/tr>\n<tr>\n<td>CommandButton3<\/td>\n<td>RESET<\/td>\n<td>RESET<\/td>\n<\/tr>\n<tr>\n<td>CommandButton4<\/td>\n<td>PndahNotaSemua<\/td>\n<td>Semua Nota<\/td>\n<\/tr>\n<tr>\n<td>CommandButton5<\/td>\n<td>PindahNotaPilih<\/td>\n<td>Nota Dipilih<\/td>\n<\/tr>\n<tr>\n<td>CommandButton6<\/td>\n<td>PindahNotaAbai<\/td>\n<td>Ketik Nilai Bayar<\/td>\n<\/tr>\n<tr>\n<td>CommandButton7<\/td>\n<td>InputKeData<\/td>\n<td>Input Ke Data<\/td>\n<\/tr>\n<\/table>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Dan terakhir, dia mengatur ukuran dan posisi masing masing control sehingga hasilnya seperti yang dia inginkan, seperti pada gambar-13 dibawah ini<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-13_excel-userform-done.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"443\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-13_excel-userform-done.png\" alt=\"tampilan FORM BAYAR setelah membuat Excel UserForm melalui Visual Basic Editor\" class=\"wp-image-1353\"\/><\/a><figcaption><em>gambar-13<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"max-width: 640px; margin: auto;\">\n<table class=\"MyTable\">\n  <tr>\n      <th>CONTROL<\/th>\n      <th>FUNGSI<\/th>\n    <\/tr>\n    <tr>\n      <td>PD<\/td>\n      <td>Untuk transaksi pembayaran dari customer<\/td>\n    <\/tr>\n    <tr>\n      <td>HD<\/td>\n      <td>Untuk transaksi pembayaran ke supplier<\/td>\n    <\/tr>\n    <tr>\n      <td>RESET<\/td>\n      <td>Membersihkan halaman BAYAR<\/td>\n    <\/tr>\n    <tr>\n      <td>CARI<\/td>\n      <td>Tempat mengetik nama yang di cari<\/td>\n    <\/tr>\n    <tr>\n      <td>ListNama<\/td>\n      <td>Menampilkan daftar nama PD\/HD<\/td>\n    <\/tr>\n    <tr>\n      <td>Ketik Nilai Bayar<\/td>\n      <td>Untuk pembayaran mengabaikan nomor nota<\/td>\n    <\/tr>\n    <tr>\n      <td>Input Ke Data<\/td>\n      <td>Menyimpan ke data utama<\/td>\n    <\/tr>\n    <tr>\n      <td>SUM<\/td>\n      <td>Menampilkan total nilai<\/td>\n    <\/tr>\n    <tr>\n      <td>ListBlnThn<\/td>\n      <td>Menampilkan bulan dan tahun nota terkait<\/td>\n    <\/tr>\n    <tr>\n      <td>ListNota<\/td>\n      <td>Menampilkan nomor nota dan nilai-nya<\/td>\n    <\/tr>\n    <tr>\n      <td>Semua Nota<\/td>\n      <td>Untuk pembayaran yang komplit<\/td>\n    <\/tr>\n    <tr>\n      <td>Nota Dipilih<\/td>\n      <td>Untuk pembayaran nomor nota yang loncat loncat<\/td>\n    <\/tr>\n<\/table>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Selesai sudah pak Adi membuat Excel UserForm melalui Visual Basic Editor. Di halaman berikut-nya pak Adi akan membuat kode-kode yang diperlukan untuk masing masing control di UserForm nya.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Apabila ada pembaca yang tidak jelas ataupun ada yang ingin ditanyakan terkait topik ini, silahkan tulis di kolom Comment. Saya akan berusaha untuk bisa menjawabnya.<\/p>\n\n\n\n<div style=\"max-width:800px;text-align:right;\"><button style=\"width:auto\"><a style=\"color:white;\" href=\"https:\/\/www.indonesiangems.com\/blog\/download\/count.php?nm=Sample04\">Download Excel UserForm Sample File<\/a><\/button><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last updated on March 19th, 2021 at 06:27 am<\/p>\n","protected":false},"author":1,"featured_media":968,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,10],"tags":[],"class_list":["post-602","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aplikasi-excel-id","category-id","tw-post-has-image-20-9","tw-meta-no-icon"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Membuat Excel UserForm melalui Visual Basic Editor VBA - part 5<\/title>\n<meta name=\"description\" content=\"Cara mudah membuat UserForm melalui Visual Basic Editor pada Excel. Disertai dengan kode kode macro-nya dan sample file untuk di download.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Membuat Excel UserForm melalui Visual Basic Editor VBA - part 5\" \/>\n<meta property=\"og:description\" content=\"Cara mudah membuat UserForm melalui Visual Basic Editor pada Excel. Disertai dengan kode kode macro-nya dan sample file untuk di download.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\" \/>\n<meta property=\"og:site_name\" content=\"Indonesian Gems Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-04T02:29:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-18T22:27:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05feature.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"7 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/#website\",\"url\":\"https:\/\/indonesiangems.com\/blog\/\",\"name\":\"Indonesian Gems Blog\",\"description\":\"just want to share what I&#039;ve done so far\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/indonesiangems.com\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05feature.jpg\",\"width\":800,\"height\":200},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/#webpage\",\"url\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\",\"name\":\"Membuat Excel UserForm melalui Visual Basic Editor VBA - part 5\",\"isPartOf\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/#primaryimage\"},\"datePublished\":\"2021-03-04T02:29:18+00:00\",\"dateModified\":\"2021-03-18T22:27:56+00:00\",\"author\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/#\/schema\/person\/96961e74ef7272e067370a6e6c4d0efd\"},\"description\":\"Cara mudah membuat UserForm melalui Visual Basic Editor pada Excel. Disertai dengan kode kode macro-nya dan sample file untuk di download.\",\"breadcrumb\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/\",\"url\":\"https:\/\/indonesiangems.com\/blog\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\",\"url\":\"https:\/\/indonesiangems.com\/blog\/excel-userform-melalui-visual-basic-editor\/\",\"name\":\"Membuat Excel UserForm melalui Visual Basic Editor VBA\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/#\/schema\/person\/96961e74ef7272e067370a6e6c4d0efd\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/73e0be4b74509a0250ea0115a8fb8b5a132592a52df5ccc0013ac50eb087f578?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/indonesiangems.com\/blog\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts\/602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/comments?post=602"}],"version-history":[{"count":136,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts\/602\/revisions"}],"predecessor-version":[{"id":1685,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts\/602\/revisions\/1685"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/media\/968"}],"wp:attachment":[{"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/media?parent=602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/categories?post=602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/tags?post=602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}