Saturday, September 1, 2007

Loading User forms with MultiPage

To select a page in a Multipage object is fairly simple. Just remember the page 1 has a value of 0, page 2 a value of 1 and so forth. To load a form with a specific page in mind, try using these codes.

Sub page2 ()
UserForm1.MultiPage1.Value = 1 'this sets page 2

UserForm1.Show 'this displays the user form after page 2 has been set
End

No comments:

Post a Comment