Now, we are starting to create the custom interface of the UserForm. Click on the right-bottom corner with the mouse cursor and drag it to resize.

If the toolbox window disappears then, go to the View tab and click on the Toolbox Then, the Toolbox window will appear again.įirst, you have to resize the user form as per your need.

If somehow, the UserForm window closes then, double click on the VBAProject > Forms > UserForms1 The window will appear again.

This is the place from where you will create all the buttons, lists, boxes, etc. There you will find another pop-up window titled Toolbox. Now, we will make a custom interface as our need.

As a result, there will create a blank UserForm with the title “ UserForm1”.

From them, select the “UserForm’” option. Here from the top menu bar, press on the “Insert” And a menu will appear.

Now, a window named “Microsoft Visual Basic for Applications” will appear.

You can use ALT + F11 to open the “Microsoft Visual Basic for Applications” window if you don’t have the Developer tab added.

For this, first, go to the top ribbon and press on the Developer, and then press on the Visual Basic option from the menu.

In this article, we will create a UserForm to take student information as input and store the data in a worksheet. If anything of this article doesn’t work in your version then leave us a comment.

But you can use any other versions as of your availability. You will find detailed explanations with clear illustrations of each thing in this article. link UserForm input data with the worksheet in Excel on Windows operating system. In this section, I will show you the quick and easy steps to create VBA Userform, initialize UserForm, to open and close UserForm. Steps to Create UserForm in Excel Using VBA

It will help you to create a large dataset avoiding any errors.

Here, I have created an Excel UserForm, through which you can take information from the students and those data will be inserted into assigned columns automatically. To insert employee or student or any information which is usually of large quantity, we can use Excel UserForm. Here, I have created an interactive UserFform through which you can give input on age, height, and weight very easily and will get the BMI value in a moment.

You will get the respective codes in the attached Excel file.īMI calculation is a very easy task and you can create a BMI calculation software with Excel VBA code easily.

Create userform excel