Excel 2019 Bible

(singke) #1

Chapter 44: Creating UserForms


44


To view or change the tab order in a UserForm, choose View ➪ Tab Order to display the Tab
Order dialog box (see Figure 44.12). 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.


FIGURE 44.12


Adjusting the tab order in a UserForm


Learning More


Mastering UserForms takes practice. You should closely examine the dialog boxes that Excel
uses to get a feeling for the way 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