VBAString Tip 8: How To Create A Simple UserForm

/ by

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:

Add this code to the “Enter” button:

That’s all. Now watch how it’s done:

Let me know if you have any questions:

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.

Please remember to subscribe to my youtube channel

Been helped? Get these!