Userform_initialize, select Multipage tab based on which previous userform button pressed?

Hi All,

I am fairly new to userform's so any help would be greatly appreciated.

Scenario - I have two userform's in excel 2013, when a button ("CommandButton3" or "CommandButton5") on the first userform (MasterPage1) is pressed it opens a second userform (Layer12) which contains a multipage. I want to select a certain tab, based on which button was pressed on the previous userform.

my code:

Private Sub UserForm_Initialize()

Select Case Application.Caller
Case "CommandButton3"
'1st tab
Me.MultiPage1.Value = 0
'3rd tab
Case "CommandButton5"
Me.MultiPage1.Value = 3
End Select

End Sub

I have also tried:

Private Sub UserForm_Initialize()

If MasterPage1.CommandButton3.Value = True Then
    Me.MultiPage1.Value = 0
ElseIf MasterPage1.CommandButton5.Value = True Then
    Me.MultiPage1.Value = 3

End If

End Sub

Neither work.
Any suggestions as to where I am going wrong would be appreciated.

Many Thanks,
Jonathan

OK, so I have found a workaround. May not be the "correct way of doing it", but it works

I do this by naming the Tag in the subroutine:

Private Sub CommandButton3_Click()

    Load Layer12
    Layer12.Tag = "Raise Purchase Order"
    Layer12.Show

End Sub

then referencing the tag using:

Private Sub UserForm_Activate()
    If Me.Tag = "edit specifications" Then Me.MultiPage1.Value = 3
    If Me.Tag = "Raise Purchase Order" Then Me.MultiPage1.Value = 0

End Sub

Sorted

Jonathan,

Welcome to the forum and thanks for posting the solution.

I have added code tags to your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE] before your code and [/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.