Question conserning userforms - multipage / page selection

[jdavis9]

When using a multipage in an userform, how do I select a specific page to open when the userform launches. For example, when I start the userform the first time, say from worksheet "rawdata", page1 will be displayed? Then, if I open it from some other sheet a different page will be displayed?
The user could obviously just select the page from the tab at the top of the multipage, but it would be nice to have the correct page displayed when opened.

Something along the lines of sheets("rawdata").select, but for userforms multipage.

 

[Andrew Poulsom]

Re: Question conserning userforms - multipage / page selecti

Like this:

Private Sub UserForm_Initialize()
    Select Case ActiveSheet.Name
        Case "Sheet1"
            MultiPage1.Value = 0
        Case "Sheet2"
            MultiPage1.Value = 1
    End Select
End Sub

 

[jdavis9]

Re: Question conserning userforms - multipage / page selecti

The value relates to the page number?

 

[jdavis9]

I was trying to make it much more complicated than it was.

Thanks again for the help......