Microsoft Office Tutorials and References
In Depth Information
Creating a UserForm
crEATing A usErforM
The first step in creating a new UserForm is to insert one into the Visual Basic Editor. To do that,
press Alt+F11 to get into the VBE, and select your workbook name in the Project Explorer as shown
in Figure 18-1.
Be careful to select the workbook you have in mind before adding a UserForm to
it! In Figure 18-1, a couple of other workbooks are open to help make the point
that the workbook of interest (“Lesson18.xlsm” in this example) is the
workbook selected in the Project Explorer.
With the workbook name selected, from the menu bar click Insert ➪ UserForm as shown in