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.