{"id":1567,"date":"2021-03-18T18:02:16","date_gmt":"2021-03-18T10:02:16","guid":{"rendered":"https:\/\/indonesiangems.com\/blog\/?p=1567"},"modified":"2021-03-19T06:27:57","modified_gmt":"2021-03-18T22:27:57","slug":"payment-userform-through-visual-basic-editor","status":"publish","type":"post","link":"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/","title":{"rendered":"Payment UserForm through Visual Basic Editor in Excel"},"content":{"rendered":"\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\/excel-userform-melalui-visual-basic-editor\/\">switch language to bahasa<\/a><\/div>\n<\/div>\n\n\n\n<p>The topic in this page is the continuation from the previous page. So now Mr. Adi is going to create a Payment UserForm through Visual Basic Editor. The difference between form in part-3 with the UserForm in this topic is : the form in part-3 is created on the worksheet &#8211; the UserForm in this topic will be created via Visual Basic Editor (VBA).<\/p>\n\n\n\n<p>This UserForm will be used to input invoice number payment, either from the accounts receivable (Customer) or to the accounts payable (Supplier).<\/p>\n\n\n\n<p>Based on Mr. Adi experience, the workflow of this form will be a little complicated because there are a few differences on how the payment is made. Basically, there are three model of the payment :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Model-A, don&#8217;t care for the invoice\/s. The focus is only to the last balance.<br>Example : The last balance is 1,123,456,789. Pay 300,000. So the balance now <br>is 823,456,789.<\/li><li>Model-B, care for the invoice\/s from a certain month. Maybe all the invoices of month X are paid, maybe only some invoices of month X are paid.<\/li><li>Model-C, care for the invoice\/s but don&#8217;t care from what month is the invoice\/s.<\/li><\/ul>\n\n\n\n<p>Each model will be explained more when the UserForm has been made on the next topic.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><em>Prepare the worksheet<\/em><\/h4>\n\n\n\n<p>Similar with part-3, the first thing Mr. Adi do is creating a new worksheet with a name &#8220;PAY&#8221;. So here, although the form will be a &#8220;standalone&#8221; form (it&#8217;s not on the worksheet) but the sheet is still needed as a helper to see the invoices which are going to be inputted to the main data.<\/p>\n\n\n\n<p>So, in sheet &#8220;PAY&#8221;, Mr. Adi fill cell C4 with <span style=\"background-color: LightGrey\">=today()<\/span> for the date when he input the payment. Fill cell B6 with &#8220;Invoice Number&#8221;, cell C6 with &#8220;VALUE&#8221;, cell E6 with &#8220;NAME&#8221; and cell F6 with &#8220;AMOUNT&#8221;. It looks like the sample image below.<\/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-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=\"Naming the worksheet.\" class=\"wp-image-1325\"\/><\/a><figcaption>Please ignore the foreign name in the image.<\/figcaption><\/figure><\/div>\n\n\n\n<p>And then he create two Pivot Tables in sheet TABLE by copying any of the existing Pivot Table then paste it on sheet TABLE.<\/p>\n\n\n\n<div style=\"background-color: LightGoldenRodYellow; padding: 20px;font-family: system-ui;\">\n<p>For the first Pivot Table, paste it on sheet TABLE cell H1, and name it &#8220;ptInvoice&#8221;.<\/p>\n<p><span style=\"text-decoration: underline;\">Arrange the fields as follow : <\/span><br>Have INV field in Row Labels area. <br>Have NAME field in Row Labels area under the INV field. <br>Have SUM field in Values area, format it as needed.<\/p>\n<p>The result looks similar with the image below.<\/p>\n<div style=\"margin:auto;max-width: 640px;\"><img decoding=\"async\" style=\"max-width: 100%;\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02a.png\" alt=\"\"><\/div>\n<\/div>\n\n\n\n<div style=\"background-color: LightCyan; padding: 20px;font-family: system-ui;\">\n<p>For the second Pivot Table, paste it on sheet TABLE cell L1, and name it &#8220;ptPayment&#8221;.<\/p>\n<p><span style=\"text-decoration: underline;\">Arrange the fields as follow : <\/span><br>Have NAME field in Report Filter area. <br>Have Y\/M field in Row Labels area.<br>Have INV field in Row Labels area, under Y\/M field.<br>Have SUM field in Values area, format it as needed.<\/p>\n<p>The result looks similar with the image below.<\/p>\n<div style=\"margin:auto;max-width: 640px;\"><img decoding=\"async\" style=\"max-width: 100%;\" src=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-02b.png\" alt=\"\"><\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><em>Designing a Payment UserForm through Visual Basic Editor<\/em><\/h4>\n\n\n\n<p>In &#8220;Developer&#8221; menu tab, click &#8220;Visual Basic&#8221; button. Mine is located on the most left of the menu, as seen in the image below.<\/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=\"Visual Basic Editor menu to create Payment UserForm.\" class=\"wp-image-1359\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Appear a Microsoft Visual Basic for Applications (VBA) window, as seen in the image below.<\/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=\"The Visual Basic Project window.\" class=\"wp-image-1360\"\/><\/a><\/figure><\/div>\n\n\n\n<p>On the left pane, there are two small windows, Project &#8211; VBAProject window and Properties window.<\/p>\n\n\n\n<p>Right-click anywhere inside the Project &#8211; VBAProjects window, click &#8220;Insert&#8221; then click &#8220;UserForm&#8221;. As seen in the image below.<\/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=\"Step to create the Payment UserForm in Excel\" class=\"wp-image-1361\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Appear another two windows. &#8220;Toolbox&#8221; window and &#8220;UserForm&#8221; (with a UserForm1 caption) window. As seen in the image below.<\/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 din visual basic editor.\" class=\"wp-image-613\"\/><\/a><\/figure><\/div>\n\n\n\n<p>In &#8220;Properties&#8221; window, change the (Name) from UserForm1 into frmPayment, and change the Caption from UserForm1 into PAYMENT FORM. As seen in the image below.<\/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>Mr. Adi resize the UserForm by dragging the bottom-right corner of the UserForm. As seen in the animation below.<\/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=\"Resize the canvas of the UserForm\" class=\"wp-image-1363\"\/><\/a><\/figure><\/div>\n\n\n\n<p>There are 5 kind of controls in Toolbox which are needed. Label, TextBox, ListBox, Frame and CommandButton. As seen in the image below.<\/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=\"The controls needed\" class=\"wp-image-621\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Just like in part-4, to create the control, just click the control in the Toolbox window, then click anywhere insidde the UserForm&#8217;s &#8220;canvas&#8221;. As seen in the animaton below.<\/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=\"Create the control\" class=\"wp-image-1364\"\/><\/a><figcaption><em>gambar-10<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>Create each control as many as the following :<\/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;\">AMOUNT<\/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-9d6595d7 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=\"All the controls needed for the Payment UserForm through Visual Basic Editor in Excel\" class=\"wp-image-711\"\/><\/a><\/figure><\/div>\n\n\n\n<p>If one of the control in the &#8220;canvas&#8221; is clicked, the Properties window will show the properties of the clicked control. As seen in the animation below.<\/p>\n<\/div>\n<\/div>\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=\"Properties of each control\" class=\"wp-image-703\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Next, Mr. Adi change the (Name) and the Caption of each control in the &#8220;Properties&#8221; window. Just click the control, then change the (Name) and the Caption in the &#8220;Properties&#8221; window as follow :<\/p>\n\n\n\n<div style=\"max-width: 640px; margin: auto;\">\n<table class=\"MyTable\">\n<tr>\n<th>Control&#8217;s default (Name)<\/th>\n<th>(Name) change to<\/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>SearchBox<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox1<\/td>\n<td>ListName<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox2<\/td>\n<td>ListYM<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>ListBox3<\/td>\n<td>ListInv<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>Frame1<\/td>\n<td><\/td>\n<td>Choose CU \/ SU<\/td>\n<\/tr>\n<tr>\n<td>Frame2<\/td>\n<td><\/td>\n<td>Collect Invoice<\/td>\n<\/tr>\n<tr>\n<td>CommandButton1<\/td>\n<td>CU<\/td>\n<td>CU<\/td>\n<\/tr>\n<tr>\n<td>CommandButton2<\/td>\n<td>SU<\/td>\n<td>SU<\/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>ColAllInv<\/td>\n<td>All Invoice<\/td>\n<\/tr>\n<tr>\n<td>CommandButton5<\/td>\n<td>ColSelectedInv<\/td>\n<td>Selected Invoice<\/td>\n<\/tr>\n<tr>\n<td>CommandButton6<\/td>\n<td>ColDisregardInv<\/td>\n<td>Type the payment value<\/td>\n<\/tr>\n<tr>\n<td>CommandButton7<\/td>\n<td>InputToData<\/td>\n<td>Input To Data<\/td>\n<\/tr>\n<\/table>\n<\/div>\n\n\n\n<p>Finally, Mr. Adi arrange the size and the position of each control according to his like. How is the size and where is the position depends on the taste of the person who designing it. Anyway in this case, Mr. Adi arrange the controls like the image below :<\/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=\"Designing Payment UserForm through Visual Basic Editor in Excel has finished.\" class=\"wp-image-1353\"\/><\/a><\/figure><\/div>\n\n\n\n<div style=\"background-color: LightGoldenRodYellow; padding: 10px;font-family: system-ui;\">\n<u>Inside the left-frame<\/u>\n<div style=\"max-width: 640px; margin: auto;\">\n<table class=\"MyTable\">\n  <tr>\n      <th>CONTROL<\/th>\n      <th>USED FOR<\/th>\n    <\/tr>\n    <tr>\n      <td>CU<\/td>\n      <td>Payment from a customer<\/td>\n    <\/tr>\n    <tr>\n      <td>SU<\/td>\n      <td>Payment to a supplier<\/td>\n    <\/tr>\n    <tr>\n      <td>RESET<\/td>\n      <td>Clear sheet PAY<\/td>\n    <\/tr>\n    <tr>\n      <td>SearchBox<\/td>\n      <td>type the name to be searched<\/td>\n    <\/tr>\n    <tr>\n      <td>ListName<\/td>\n      <td>Name list found based on the typed word<\/td>\n    <\/tr>\n    <tr>\n      <td>Type the payment value<\/td>\n      <td>Payment which disregard invoice number<\/td>\n    <\/tr>\n    <tr>\n      <td>Input To Data<\/td>\n      <td>Put collected invoices to the main data<\/td>\n    <\/tr>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n<div style=\"background-color: LightCyan; padding: 10px;font-family: system-ui;\">\n<u>Inside the right-frame<\/u>\n<div style=\"max-width: 640px; margin: auto;\">\n<table class=\"MyTable\">\n  <tr>\n      <th>CONTROL<\/th>\n      <th>USED FOR<\/th>\n    <\/tr>\n    <tr>\n      <td>SUM<\/td>\n      <td>SUM value of the invoices<\/td>\n    <\/tr>\n    <tr>\n      <td>ListYM<\/td>\n      <td>The Month and Year of the invoice<\/td>\n    <\/tr>\n    <tr>\n      <td>ListInv<\/td>\n      <td>Invoice List based on the selected element<\/td>\n    <\/tr>\n    <tr>\n      <td>All Invoices<\/td>\n      <td>Collect invoice&#8217;s based on the selected element<\/td>\n    <\/tr>\n    <tr>\n      <td>Selected Invoice<\/td>\n      <td>Collect the invoice based on the selected invoice<\/td>\n    <\/tr>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n<p>That&#8217;s it. The designing stage to make the Payment UserForm through Visual Basic Editor in Excel has finished. In the next topic, Mr. Adi will make the macro code for the controls in this UserForm.<\/p>\n\n\n\n<p>If there is something which is not clear regarding to this topic, please don\u2019t hesitate to ask in the Comment box. I\u2019ll try my best to answer.<\/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-En\">Download Excel UserForm Sample File (English version)<\/a><\/button><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12],"tags":[],"class_list":["post-1567","post","type-post","status-publish","format-standard","hentry","category-en","category-excel-application-en","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>Payment UserForm through Visual Basic Editor in Excel - Designing Stage<\/title>\n<meta name=\"description\" content=\"Designing stage on making a Payment UserForm through Visual Basic Editor in Excel. Easy to follow. Suitable for a beginner.\" \/>\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\/payment-userform-through-visual-basic-editor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Payment UserForm through Visual Basic Editor in Excel - Designing Stage\" \/>\n<meta property=\"og:description\" content=\"Designing stage on making a Payment UserForm through Visual Basic Editor in Excel. Easy to follow. Suitable for a beginner.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/\" \/>\n<meta property=\"og:site_name\" content=\"Indonesian Gems Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-18T10:02:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-18T22:27:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-01_worksheet-payment.png\" \/>\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=\"8 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\/payment-userform-through-visual-basic-editor\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/indonesiangems.com\/blog\/wp-content\/uploads\/2021\/03\/05-01_worksheet-payment.png\",\"width\":774,\"height\":376},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/#webpage\",\"url\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/\",\"name\":\"Payment UserForm through Visual Basic Editor in Excel - Designing Stage\",\"isPartOf\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/#primaryimage\"},\"datePublished\":\"2021-03-18T10:02:16+00:00\",\"dateModified\":\"2021-03-18T22:27:57+00:00\",\"author\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/#\/schema\/person\/96961e74ef7272e067370a6e6c4d0efd\"},\"description\":\"Designing stage on making a Payment UserForm through Visual Basic Editor in Excel. Easy to follow. Suitable for a beginner.\",\"breadcrumb\":{\"@id\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-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\/payment-userform-through-visual-basic-editor\/\",\"url\":\"https:\/\/indonesiangems.com\/blog\/payment-userform-through-visual-basic-editor\/\",\"name\":\"Payment UserForm through Visual Basic Editor in Excel\"}}]},{\"@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\/1567","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=1567"}],"version-history":[{"count":33,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts\/1567\/revisions"}],"predecessor-version":[{"id":1620,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/posts\/1567\/revisions\/1620"}],"wp:attachment":[{"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/media?parent=1567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/categories?post=1567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/indonesiangems.com\/blog\/wp-json\/wp\/v2\/tags?post=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}