Calling Userform to specific tab (page)?

[BAlGaInTl]

Hey all...

I have a userform with multiple tabs (pages). Is there a way that I can call the userform and have it load displaying a tab other than the default tab?

Any help is appreciated.

TIA

 

[Haluk]

The following code, activates the 2nd page of the MultiPage when the UserForm initializes;

Private Sub UserForm_Initialize()
MultiPage1.Value = 1
End Sub

Similarly you can decide on which page to be activated when the UserForm is initialized by;

Inserting the following to the UserForm code module:

Private Sub UserForm_Initialize()
MultiPage1.Value = MyPage
End Sub

And inserting the following in a standart code module, where the page index is declared as a public variable;

Public MyPage As Integer
'
Sub CallForm()
MyPage = 1
UserForm1.Show
End Sub

 

[BAlGaInTl]

The following code, activates the 2nd page of the MultiPage when the UserForm initializes;

Private Sub UserForm_Initialize()
MultiPage1.Value = 1
End Sub

The form is rather long, and 90% of the time, the user will start with the first page.

I would rather not have to re-initialize the entire form just to get the 3rd page to show automatically.

Is there a way to use

DataEntry.Show

in some fashion? If not, maybe I will just tell the lazy users to click on the proper tab themselves when the form loads. :D

 

[Haluk]

By changing the UserForm and related object names (or the page index which is stored in the public variable, Mypage) , the solutions given above should do the trick.

 

[BAlGaInTl]

Perfect,

Thank you for your help.