PDA

View Full Version : Multipage Active Tab



zagrijs
10-11-2011, 06:06 AM
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.

gmaxey
10-11-2011, 06:16 AM
Just visiting, but how about using the Initialize event:

Private Sub UserForm_Initialize()
MultiPage1.Value = 1 'Displays the "second" tab.
End Sub

zagrijs
10-11-2011, 06:36 AM
Pretty obvious! I looked for all kinds of complicated answers that just did not work.

Thanks!!!!