Identifying which tab of a UserForm MultiPage is selected

[MattOCUSA]

I have 2 tabs on a UserForm. I am referring to the "MultiPage" object of my user form, not the "TabStrip."

I set up my user form with 2 Tabs on the top of it. Once either tab is completed by the user, they can click a Go button which is below the bottom of the MultiPage tab layout of the UserForm. So, to clarify, whether the user is inputting info on Tab1 or Tab2, they always see the SAME Go button below the MultiPage tab's on my user form. My problem now is I need to know if the user completed Tab1 or Tab2? I'd rather not test if a box is blank on either form or not, I'm hoping I can test for which tab is currently shown/selected by the user when they press go?

Thank You,
Matt

 

[Ivan F Moala]

MsgBox MultiPage1.Pages(MultiPage1.Value).Name

gives the name of the Tab

 

[Joe Was]

This will test which Page is Active when the Command Button is pressed:


Private Sub CommandButton1_Click()
'UserForm code module code only!
Dim lngTabIndx&

lngTabIndx = MultiPage1.Value

If lngTabIndx = 0 Then
MsgBox "Page1"

ElseIf lngTabIndx = 1 Then
MsgBox "Page2"
End If

MsgBox lngTabIndx
End Sub

 

[MattOCUSA]

Thanks you guys, I really apreciate it.

Matt