Inserting UserForms

One of the first tasks you will want to perform when building a VBA program is to insert a UserForm. This is the area where you develop the interface, or window that users will see when they run the program.

To insert a UserForm

1. From the Insert menu in the VBA Editor, click UserForm. A blank UserForm is displayed, along with the Toolbox , which contains controls that you can insert on your UserForm.

Tell me about...

VBA (Visual Basic for Applications)

Overview of automation

Starting VBA

Adding controls to a UserForm

Creating code

Using modules

Managing VBA projects

Running a VBA program