-
Multipage Active Tab
Is there a way to activate a specific tab of a multipage before the form loads/show?
I have a form with a multipage, each page relating to a different worksheet. I managed to code the multipage_change event so that the worksheet page relating to that page will be activated when the tab is clicked. My application would benefit greatly if I could open the form from any worksheet with the correct page of the multipage already selected.
-
Just visiting, but how about using the Initialize event:
[VBA]Private Sub UserForm_Initialize()
MultiPage1.Value = 1 'Displays the "second" tab.
End Sub
[/VBA]
-
Pretty obvious! I looked for all kinds of complicated answers that just did not work.
Thanks!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules