Microsoft Office Tutorials and References
In Depth Information
Displaying a Progress Indicator
Figure 15-5: The user specifies the number of rows and columns for the random numbers.
The first step is to add a MultiPage control to your UserForm. Then move all the existing
controls on the UserForm and paste them to Page1 of the MultiPage control.
Next, activate Page2 of the MultiPage control and set it up as shown in Figure 15-6. This is
essentially the same combination of controls used in the example in the previous section.
Add a Frame control and name it FrameProgress .
Add a Label control inside the Frame, name it LabelProgress , remove the label’s
caption, and make its background color red.
Add another label to describe what’s going on (optional).
Next, activate the MultiPage control itself (not a page on the control) and set its
Style property to 2 – fmTabStyleNone .
(This will hide the tabs.) You’ll probably need to adjust the size of the MultiPage
control to account for the fact that the tabs aren’t displayed.
The easiest way to select the MultiPage control when the tabs are hidden is to use the
drop-down list in the Properties window. To select a particular page, specify a Value
for the MultiPage control: 0 for Page1 , 1 for Page2 , and so on.