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.

Was this article helpful?

0 0
Black Jack Tactics Conquering The Game In Casinos

Black Jack Tactics Conquering The Game In Casinos

So, you want to learn how to play Blackjack. Youre in good hands. There is no better ship to chart those learning waters than the one youre riding on right now.

Get My Free Ebook


Post a comment