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

Before you unleash a UserForm on end users, be sure that everything is working correctly. The following checklist should help you identify potential problems.

• Are similar controls the same size ?

• Are the controls evenly spaced ?

• Is the dialog box too overwhelming? If so, you may want to group the controls by using a MultiPage control.

• Can every control be accessed with a hot key?

• Are any of the hot keys duplicated ?

• Is the tab order set correctly?

• Will your VBA code take appropriate action if the user presses Esc or clicks the Close button on the UserForm?

• Are there any misspellings in the text?

• Does the dialog box have an appropriate caption?

• Will the dialog box display properly at all video resolutions ?

• Are the controls grouped logically (by function)?

• Do ScrollBar and SpinButton controls allow valid values only?

• Are ListBoxes set properly (Single, Multi, or Extended)? See Chapter 14 for details on ListBox controls.