Example The Activate Sheet Utility

It is time now to implement the ActivateSheet utility in our SRXUtils application. This will demonstrate the use of UserForms.

Teal47 ly®

In particular, when the user selects ActivateSheet, we would like to present her with a custom dialog that lists all of the sheets in the active workbook, as shown in Figure 14-5. The user can select one of these sheets, which will then be activated.

Figure 14-5. The activate sheet dialog

Figure 14-5. The activate sheet dialog

To implement this utility, we need to do the following:

• Change the ActivateSheet procedure in basMain to open the Activate Sheet dialog (instead of displaying the current message).

• Design the Activate Sheet dialog itself.

• Write the code behind the Activate Sheet dialog.

0 0

Post a comment