Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

2017-07-07 02:10:07

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 default names like UserForm1 , UserForm2 , and so on.

Tip	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.

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.

Категории