Multipage function - 1st page doesn't show

  • Thread starter Thread starter prahz
  • Start date Start date
P

prahz

I have made a user form in excel vba. In it I have a multipage form
"multipage1" with two pages: "partsPage" and "inventoryPage."

When I run my script, the multipage tabs show up, however the contents
of the first page do not automatically show up (ie the first page looks
like it is blank). I have to manually click the first page's tab for
the contents to actually show up. How do I make it to where the
conents of the first page "partsPage" show up automatically without the
user having to click anything? partsPage is indexed as 0 and the other
page's index is 1 so i know I have that right.

This is kind of a hard one to explain but hopefully those of you with
more experience than I know where I am trying to get at.

Thanks.
 
In your Userform window, select your multipage and set it's value property
to 0
or I think something like this would work.
Private Sub UserForm_Initialize()
Me.MultiPage1.Value = 0
End Sub

keizi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top