Microsoft Office Tutorials and References
In Depth Information
Many applications incorporate wizards to guide users through an operation. Excel’s Text Import
Wizard is a good example. A wizard is essentially a series of dialog boxes that solicit information
from the user. Usually, the user’s choices in earlier dialog boxes influence the contents of later
dialog boxes. In most wizards, the user is free to go forward or backward through the dialog box
sequence or to click the Finish button to accept all defaults.
You can create wizards by using VBA and a series of UserForms. However, I’ve found that the
most efficient way to create a wizard is to use a single UserForm and a MultiPage control with
the tabs hidden.
Figure 15-9 shows an example of a simple four-step wizard, which consists of a single UserForm
that contains a MultiPage control. Each step of the wizard displays a different page in the
Figure 15-9: This four-step wizard uses a MultiPage control.
The wizard example in this section is available on the companion CD-ROM. The file is
named wizard demo.xlsm .
The sections that follow describe how I created the sample wizard.