Showing a progress indicator by using a Multi Page control

In the preceding example, the macro was not initiated by a UserForm. If your lengthy macro is kicked off when a UserForm is displayed, however, the technique that I describe in this section is a better solution. It assumes the following:

♦ Your project is completed and debugged.

♦ Your project uses a UserForm (without a MultiPage control) to initiate a lengthy macro.

♦ You have a way to gauge the progress of your macro.

The companion CD-ROM contains an example that demonstrates this technique.

0 0

Post a comment