In this tip I am going to show you how to create a simple userform in Excel
You are going to find out how to show the userform and transfer the data from your userform
to your worksheet.
If you want more advanced userform tips, click on the “UserForm” category on the right of the screen.
1. Right click in the VBE, and insert a UserForm.
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.
Add a button to the worksheet, to show the userform.
The macro code is:
Sub Button1_Click() UserForm1.Show End Sub
Add this code to the “Enter” button:
Private Sub btnEnter_Click() Range("A1") = Me.txtFname Range("B1") = Me.txtLname End Sub
That’s all. Now watch how it’s done:
Let me know if you have any questions:
[simple_contact_form]