Multipage function - 1st page doesn't show

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prahz - 07 Dec 2006 22:44 GMT

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.

Reply to this Message

kounoike - 08 Dec 2006 01:35 GMT

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

>I have made a user form in excel vba. In it I have a multipage form
> "multipage1" with two pages: "partsPage" and "inventoryPage."
[quoted text clipped - 11 lines]
>
> Thanks.

Reply to this Message

kounoike - 08 Dec 2006 02:35 GMT

Ignore my post. It's seems like to misread your post.

keizi

> In your Userform window, select your multipage and set it's value property
> to 0
[quoted text clipped - 20 lines]
>>
>> Thanks.

Reply to this Message

Rate this thread: