Inserting a New User Form

To insert a new UserForm, activate the VBE (press Alt+F11), select your workbook's project from the Project window, and then choose Insert ^ UserForm. UserForms have names like UserForml, UserForm2, and so on.

You can change the name of a UserForm to make it easier to identify. Select the form and use the Properties window to change the Name property. (Press F4 if the Properties window is not displayed.) Figure 13-1 shows the Properties window when an empty UserForm is selected.

Excel Window Figure Description
Figure 13-1: The Properties window for an empty UserForm.

A workbook can have any number of UserForms, and each UserForm holds a single custom dialog box.

Was this article helpful?

0 0


Post a comment