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.