{"id":145,"date":"2018-11-16T18:08:14","date_gmt":"2018-11-16T18:08:14","guid":{"rendered":"http:\/\/www.vbastring.com\/blog\/?p=145"},"modified":"2018-11-16T18:21:19","modified_gmt":"2018-11-16T18:21:19","slug":"vbastring-tip-8-how-to-create-a-simple-userform","status":"publish","type":"post","link":"https:\/\/vbastring.com\/blog\/2018\/11\/16\/vbastring-tip-8-how-to-create-a-simple-userform\/","title":{"rendered":"VBAString Tip 8: How To Create A Simple UserForm"},"content":{"rendered":"

In this tip I am going to show you how to create a simple userform in Excel<\/p>\n

You are going to find out how to show the userform and transfer the data from your userform
\nto your worksheet. <\/p>\n

If you want more advanced userform tips, click on the “UserForm” category on the right of the screen.<\/p>\n

1. Right click in the VBE, and insert a UserForm.<\/p>\n

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

Use the toolbox to add 2 controls for “First Name” and “Last Name”. Add a 3rd control, a command button, to enter into the worksheet the values from the userform.<\/p>\n

Add a button to the worksheet, to show the userform. <\/p>\n

The macro code is:<\/p>\n

Sub Button1_Click()\r\n    UserForm1.Show\r\nEnd Sub\r\n<\/pre>\n
\"\"<\/a><\/p>\n
Add this code to the “Enter” button:<\/p>\n
Private Sub btnEnter_Click()\r\n    Range(\"A1\") = Me.txtFname\r\n    Range(\"B1\") = Me.txtLname\r\n    \r\nEnd Sub\r\n<\/pre>\n
That’s all.  Now watch how it’s done:<\/p>\n