multi page user form 1

[d23]

All,

I am using a "multi-page userform" to perform several static calculations in a file. The multi page user form always opens to the first sheet tab in the user form. Is there some way to open a multi page user form on a page (sheet tab) other than page 1?

Thanks
D23

 

[davidbeach]

What program?

 

[d23]

davidbeach

It is in EXCEL.

D23

 

[davidbeach]

excel always opens to the worksheet it was on when closed.

 

[d23]

davidbeach,

I'm asking about a userform (VB) in EXCEL, not the file.

D23

 

[satchmo]

in the Form Initialize event set the multipage value equal to 0. Here is an example:

Private Sub UserForm_Initialize()
Me.MultiPage1.Value = 0
End Sub

 

[d23]

satchmo,

Thnaks for the code. I have to add a few if's and I'm good to go!

D23

 

[satchmo]

Glad it worked for you.