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

A custom dialog box is created on a UserForm, and you access UserForms in the Visual Basic Editor (VBE).

Following is the typical sequence that you will follow when you create a UserForm:

  1. Insert a new UserForm into your workbook's VB Project.

  2. Write a procedure that will display the UserForm. This procedure will be located in a VBA module (not in the code module for the UserForm).

  3. Add controls to the UserForm.

  4. Adjust some of the properties of the controls that you added.

  5. Write event handler procedures for the controls. These procedures, which are located in the code window for the UserForm, are executed when various events (such as a button click) occur.

Related

Категории