Consulting

Results 1 to 3 of 3

Thread: Multipage Active Tab

  1. #1
    VBAX Regular
    Joined
    Sep 2011
    Posts
    78
    Location

    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.

  2. #2
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,335
    Location
    Just visiting, but how about using the Initialize event:

    [VBA]Private Sub UserForm_Initialize()
    MultiPage1.Value = 1 'Displays the "second" tab.
    End Sub
    [/VBA]
    Greg

    Visit my website: http://gregmaxey.com

  3. #3
    VBAX Regular
    Joined
    Sep 2011
    Posts
    78
    Location
    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
  •