Page 457 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects

Creating Advanced User Forms
As the vbModal value implies, once the form is displayed, it remains on the screen, preventing
the user from accessing any part of the Excel worksheet underneath it. If it’s important to
provide this level of access, you can switch the vbModal value to vbModeless. Then the user
will be able to switch between the form and the worksheet. (See Figure 20-4.)

Chapter 20

Figure 20-4. The user can switch between the form and Excel if the form is displayed using
vbModeless value.

Warning Use the vbModeless value with care. In this example, allowing the user to
access the underlying worksheet also permits the user to change the data that’s currently
displayed on the user form. If this happens and the user presses the Save button, any
changes that the user might have made directly to the row will be lost.

Building a Multi-Step Wizard

The other example in this chapter shows you how to build a multi-step wizard that’s invoked
from Excel’s menus. This example gives you the framework with which to develop your own
wizards.

Wizard Application Overview

The wizard in this example merely collects information over several steps and summarizes
the information in the final step. Step 1 of the wizard (shown in Figure 20-5) presents the user
a choice of four different options using OptionButton controls that are nested inside a single
frame control. Notice that the Prev button is disabled because this is the first step of the wizard.

431