Excel 2010 Bible

(National Geographic (Little) Kids) #1

Chapter 41: Creating UserForms


857


you should make sure that the tab order is correct. Usually, it means that tabbing should move
through the controls in a logical sequence.


To view or change the tab order in a UserForm, choose View ➪ Tab Order to display the Tab
Order dialog box. You can then select a control from the list; use the Move Up and Move Down
buttons to change the tab order for the selected control.


Learning More


Mastering UserForms takes practice. You should closely examine the dialog boxes that Excel uses
to get a feeling for how dialog boxes are designed. You can duplicate many of the dialog boxes that
Excel uses.


The best way to learn more about creating dialog boxes is by using the VBA Help system. Pressing
F1 is the quickest way to display the Help window.

Free download pdf