{"id":12138,"date":"2012-06-05T18:27:02","date_gmt":"2012-06-05T18:27:02","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1690"},"modified":"2022-08-06T22:59:58","modified_gmt":"2022-08-06T22:59:58","slug":"excel-macro-tutorial-excel-form","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/","title":{"rendered":"Excel Macro Tutorial : Excel Form"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going to learn the following things about VBA User Form:<\/strong><\/p>\n

\n
\n1. How to Create User Form (Creating VBA Form)
\n2. Showing a VBA Form (Display an Excel Form)
\n3. How to Initialize a UserForm
\n4. Hiding a VBA Form
\n5. Unloading VBA Form
\n6. Closing VBA Form
\n7. Example: Creating Data Entry Form using Excel Form
\n8. Free Download: Data Entry Form using Excel Form<\/p>\n

<\/font>\n<\/div>\n

1. How to Create User Form (Creating VBA Form)<\/h1>\n

Creating a Form (Designing a Form) in excel is very easy and interesting. For Designing a Form a single Line Code is not required. Code is required only to make that Form function as per your requirement.
\nTo create a Form, follow the below simple steps:
\n
\nStep 1. <\/strong> Open your Workbook and Press Alt + F11<\/strong>
\nStep 2. <\/strong> VB Code Editor will open as below
\n
\n\"User
\n<\/p>\n

Step 4. <\/strong> Right Click on Microsoft Excel Object<\/strong>
\nStep 5. <\/strong> Go to Insert –> User Form <\/strong>
\n
\n\"User<\/a><\/p>\n

Step 6. <\/strong> In Right Side you can see one Default UserForm1 Created. You can see the ToolBox as well with all the Controls available for the User Form.<\/p>\n

\n\"User<\/a>
\n<\/p>\n

Step 7. <\/strong> Using the Tool Box of the User Form you can Drag and Drop what all Controls you want on your form.
\nRefer the below User form which I have created to show as an example. You can design by your own how you want.
\n
\n\"User<\/a>
\n<\/p>\n

2. Showing a VBA Form (Display an Excel Form): <\/strong><\/font> As you have seen we have created the User Form in VBA Code. User form will not be displaying on the Excel Sheet by default. To display the form we need to write a piece of code. This is just a single statement to launch an Existing User Form. You can execute that statement to open User form.<\/p>\n

\r\nUserForm1.Show<\/strong>\r\n<\/code>\r\n<\/pre>\n
You can add the above statement where you want to launch your user form. UserForm1<\/strong> is the name of the User Form Control.<\/p>\n
3. How to Initialize a VBA Form: <\/h1>\n
Before getting in to technical details lets discuss, what is Initialization of User form? Initialization of User Form is nothing but to do some default operation while launching the Form. At the time of loading the User Form, we set certain values or any kind of defaulting to any field, comes under Initialization. <\/p>\n
\nWhatever code is there in UserForm_Initialize()<\/strong> Event of User Form, will be executed as soon as User Form will be launched (Shown).
\nClick on the User Form and you will be taken to the below Private Sub with Initialize Event as shown in Image below:\n<\/p>\n\"VBA<\/a>\n
Example:<\/h3>\n
\r\n\r\nPrivate Sub UserForm_Initialize()\r\n\r\nUserForm1.ComboBox1.Clear\r\n With UserForm1.ComboBox1\r\n    .AddItem \"Junior Engineer\"\r\n    .AddItem \"Engineer\"\r\n    .AddItem \"Team Lead\"\r\n    .AddItem \"Technical Lead\"\r\n    .AddItem \"Functional Consultant\"\r\n    .AddItem \"Technical Consultant\"\r\n    .AddItem \"Project Manager\"\r\n    .AddItem \"Delivery Manager\"\r\n    .AddItem \"Group Delivery Manager\"\r\n    .AddItem \"Unit Head\"\r\n    .AddItem \"Regional Head\"\r\n End With\r\nEnd Sub\r\n<\/code><\/pre>\n
 4. Closing and Hiding and Unloading a VBA Form: <\/h1>\n
Like windows dialog box User Form also has a by default Cross Button to close the form. It will simply close the User form. There is a difference between Closing<\/strong> and  hiding <\/strong> a user form.<\/p>\n
Closing a User form will close the User Form. All the value entered in to that form will be cleared (lost) when you launch it again. Whereas on hiding a user form all the vaues entered in to that form will remain there and can be seen again once you launch the user form again. Both the terms (Closing and hiding) are pretty much self explanatory.\n<\/p>\n
Closing or Unloading an Excel User form are same. In VBA Code, to close an Excel Form, Unload<\/strong> keyword is used. This is the reason we call it both either closing a VBA Form or Unloading a VBA Form.\n\t<\/p>\n
Now you know the about Closing, Hiding and Unloading an Excel UserForm. Now i will show you the VBA syntax for Unloading (Closing) and Hiding with an Example.\n<\/p>\n\n\n\n
\n\t\tHiding a User Form: <\/strong><\/font>
\n\t\t\ti)  Syntax:<\/strong><\/i>
\n\t\t\t\t<UserForm Name>.Hide
\n\t\t\tii) Example:<\/strong><\/i>
\n\t\t\t\tPrivate Sub UserForm_Click()
\n\t\t\t\t\tUserForm1.Hide
\n\t\t\t\tEnd Sub<\/p>\n<\/td>\n		\n\"User<\/a>\n<\/td>\n<\/tr>\n
\n\t\tUnloading or Closing a User Form: <\/strong><\/font>
\n\t\t\ti)  Syntax:<\/strong><\/i>
\n\t\t\t\tUnload <User Form Name> OR<\/strong> Unload Me
\n\t\t\tii) Example:<\/strong><\/i>
\n\t\t\t\tPrivate Sub UserForm_Click()
\n\t\t\t\t\tUnload UserForm1 OR<\/strong> Unload Me
\n\t\t\t\tEnd Sub<\/p>\n<\/td>\n<\/tr>\n<\/table>\n
5. Example: Creating Data Entry Form using Excel Form: <\/h1>\n
Now its time for doing some hands-on. I have created one Simple Data Entry Form using Excel VBA Form as shown below in Image. If you wish to see the Code and the whole Workbook download it from below:<\/p>\n
\"Employee
Employee Data Entry Form – Excel VBA<\/p><\/div>\n
[\/et_pb_text][et_pb_cta _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” button_url=”\/excel\/\/wp-content\/downloads\/Employee_Record_Form.xls” title=”Download FREE – Employee Data Entry Form” button_text=”Download Now” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n
\nTo Check out more Excel Macro Tutorials, visit Excel Macro Tutorial<\/a><\/strong>\n<\/div>\n
\nDownload this FREE Excel workbook to practice. <\/p>\n
[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going to learn the following […]<\/p>\n","protected":false},"author":45,"featured_media":242500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going to learn the following things about VBA User Form:<\/strong>\r\n\r\n
\r\n\r\n1. How to Create User Form (Creating VBA Form)\r\n2. Showing a VBA Form (Display an Excel Form)\r\n3. How to Initialize a UserForm\r\n4. Hiding a VBA Form\r\n5. Unloading VBA Form\r\n6. Closing VBA Form\r\n7. Example: Creating Data Entry Form using Excel Form\r\n8. Free Download: Data Entry Form using Excel Form\r\n\r\n<\/font>\r\n<\/div>\r\n\r\n
1. How to Create User Form (Creating VBA Form)<\/h1>\r\n Creating a Form (Designing a Form) in excel is very easy and interesting. For Designing a Form a single Line Code is not required. Code is required only to make that Form function as per your requirement.\r\nTo create a Form, follow the below simple steps:\r\n\r\nStep 1. <\/strong> Open your Workbook and Press Alt + F11<\/strong>\r\nStep 2. <\/strong> VB Code Editor will open as below\r\n\r\n\"User\r\n\r\n\r\nStep 4. <\/strong> Right Click on Microsoft Excel Object<\/strong>\r\nStep 5. <\/strong> Go to Insert --> User Form <\/strong>\r\n\r\n[caption id=\"attachment_1716\" align=\"aligncenter\" caption=\"User Form - Add-New-Form\"]\"User<\/a>[\/caption]\r\n\r\n\r\nStep 6. <\/strong> In Right Side you can see one Default UserForm1 Created. You can see the ToolBox as well with all the Controls available for the User Form.\r\n\r\n\r\n[caption id=\"attachment_1717\" align=\"aligncenter\" caption=\"User Form - Add-New-Form-With-Tool Box\"]\"User<\/a>[\/caption]\r\n\r\n\r\nStep 7. <\/strong> Using the Tool Box of the User Form you can Drag and Drop what all Controls you want on your form.\r\nRefer the below User form which I have created to show as an example. You can design by your own how you want.\r\n\r\n[caption id=\"attachment_1718\" align=\"aligncenter\" caption=\"User Form - Data Entry Form\"]\"User<\/a>[\/caption]\r\n\r\n\r\n 2. Showing a VBA Form (Display an Excel Form): <\/strong><\/font> As you have seen we have created the User Form in VBA Code. User form will not be displaying on the Excel Sheet by default. To display the form we need to write a piece of code. This is just a single statement to launch an Existing User Form. You can execute that statement to open User form.\r\n\r\n
\r\nUserForm1.Show<\/strong>\r\n<\/code>\r\n<\/pre>\r\n\r\nYou can add the above statement where you want to launch your user form. UserForm1<\/strong> is the name of the User Form Control.\r\n\r\n\r\n
3. How to Initialize a VBA Form: <\/h1> \r\nBefore getting in to technical details lets discuss, what is Initialization of User form? Initialization of User Form is nothing but to do some default operation while launching the Form. At the time of loading the User Form, we set certain values or any kind of defaulting to any field, comes under Initialization. \r\n\r\n
\r\nWhatever code is there in UserForm_Initialize()<\/strong> Event of User Form, will be executed as soon as User Form will be launched (Shown). \r\nClick on the User Form and you will be taken to the below Private Sub with Initialize Event as shown in Image below:\r\n<\/p>\r\n[caption id=\"attachment_1731\" align=\"aligncenter\" caption=\"VBA Form - Initialization\"]\"VBA<\/a>[\/caption] \r\n\r\n
Example:<\/h3>\r\n
\r\n\r\nPrivate Sub UserForm_Initialize()\r\n\r\nUserForm1.ComboBox1.Clear\r\n With UserForm1.ComboBox1\r\n    .AddItem \"Junior Engineer\"\r\n    .AddItem \"Engineer\"\r\n    .AddItem \"Team Lead\"\r\n    .AddItem \"Technical Lead\"\r\n    .AddItem \"Functional Consultant\"\r\n    .AddItem \"Technical Consultant\"\r\n    .AddItem \"Project Manager\"\r\n    .AddItem \"Delivery Manager\"\r\n    .AddItem \"Group Delivery Manager\"\r\n    .AddItem \"Unit Head\"\r\n    .AddItem \"Regional Head\"\r\n End With\r\nEnd Sub\r\n<\/code><\/pre>\r\n\r\n\r\n
 4. Closing and Hiding and Unloading a VBA Form: <\/h1>\r\nLike windows dialog box User Form also has a by default Cross Button to close the form. It will simply close the User form. There is a difference between Closing<\/strong> and  hiding <\/strong> a user form.\r\n
Closing a User form will close the User Form. All the value entered in to that form will be cleared (lost) when you launch it again. Whereas on hiding a user form all the vaues entered in to that form will remain there and can be seen again once you launch the user form again. Both the terms (Closing and hiding) are pretty much self explanatory. \r\n<\/p>\r\n
Closing or Unloading an Excel User form are same. In VBA Code, to close an Excel Form, Unload<\/strong> keyword is used. This is the reason we call it both either closing a VBA Form or Unloading a VBA Form.\r\n\t<\/p>\r\n\r\n
Now you know the about Closing, Hiding and Unloading an Excel UserForm. Now i will show you the VBA syntax for Unloading (Closing) and Hiding with an Example.\r\n<\/p>\r\n\t\r\n\t\r\n\t \r\n\t\t
\r\n\t\tHiding a User Form: <\/strong><\/font>\r\n\t\t\ti)  Syntax:<\/strong><\/i>\r\n\t\t\t\t.Hide\r\n\t\t\tii) Example:<\/strong><\/i>\r\n\t\t\t\tPrivate Sub UserForm_Click()\r\n\t\t\t\t\tUserForm1.Hide\r\n\t\t\t\tEnd Sub\r\n\t\t\t\t\r\n\t\t<\/td>\r\n\t\t\r\n\t\t\r\n\t\t[caption id=\"attachment_1719\" align=\"aligncenter\" caption=\"User Form - How to hide\"]\"User<\/a>[\/caption]\r\n\t\t\r\n\t\t<\/td>\r\n\t\t<\/tr>\r\n\t\t
\r\n\t\tUnloading or Closing a User Form: <\/strong><\/font>\r\n\t\t\ti)  Syntax:<\/strong><\/i>\r\n\t\t\t\tUnload  OR<\/strong> Unload Me\r\n\t\t\tii) Example:<\/strong><\/i>\r\n\t\t\t\tPrivate Sub UserForm_Click()\r\n\t\t\t\t\tUnload UserForm1 OR<\/strong> Unload Me\r\n\t\t\t\tEnd Sub\r\n\t\t\t\t\r\n\t\t<\/td>\r\n\t\t<\/tr>\r\n\t<\/table>\r\n\t\t\r\n\r\n
5. Example: Creating Data Entry Form using Excel Form: <\/h1>\r\nNow its time for doing some hands-on. I have created one Simple Data Entry Form using Excel VBA Form as shown below in Image. If you wish to see the Code and the whole Workbook download it from below:\r\n
\r\n[caption id=\"attachment_6487\" align=\"aligncenter\" width=\"300\"]\"Employee Employee Data Entry Form - Excel VBA[\/caption]\r\n\r\n<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[1246,1675,1682],"tags":[],"class_list":["post-12138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-for-beginners","category-popular-articles"],"yoast_head":"\nExcel Macro Tutorial : Excel Form - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : Excel Form\" \/>\n<meta property=\"og:description\" content=\"In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going to learn the following […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-05T18:27:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-06T22:59:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"615\" \/>\n\t<meta property=\"og:image:height\" content=\"498\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : Excel Form\",\"datePublished\":\"2012-06-05T18:27:02+00:00\",\"dateModified\":\"2022-08-06T22:59:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\"},\"wordCount\":987,\"commentCount\":35,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Tutorial\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\",\"name\":\"Excel Macro Tutorial : Excel Form - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png\",\"datePublished\":\"2012-06-05T18:27:02+00:00\",\"dateModified\":\"2022-08-06T22:59:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png\",\"width\":615,\"height\":498},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Tutorial : Excel Form\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Macro Tutorial : Excel Form - Let's excel in Excel","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:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : Excel Form","og_description":"In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going to learn the following […]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-06-05T18:27:02+00:00","article_modified_time":"2022-08-06T22:59:58+00:00","og_image":[{"width":615,"height":498,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : Excel Form","datePublished":"2012-06-05T18:27:02+00:00","dateModified":"2022-08-06T22:59:58+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/"},"wordCount":987,"commentCount":35,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png","articleSection":["Excel Macro","Excel Macro Tutorial","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/","url":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/","name":"Excel Macro Tutorial : Excel Form - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png","datePublished":"2012-06-05T18:27:02+00:00","dateModified":"2022-08-06T22:59:58+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Employee-Data-Entry-Form-1.png","width":615,"height":498},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-excel-form\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Tutorial : Excel Form"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12138"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12138"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12138\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242500"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}