How Excel Handles Custom Dialog Boxes


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.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net