Solved: use multipage as button

[Djblois]

I am using a multipage function on my form but the last page I want to consider a button. Can I make it so when someone clicks on the last page tab (named Advanced) it runs code to bring up another form instead of switching pages?

[dansam]

Hi Djblois,
This may be help you :
Private Sub MultiPage1_Change()
Dim n As String
n = MultiPage1.Pages.Count
If MultiPage1.Value = n - 1 Then
Unload Me
UserForm2.Show ' name of that userform which you want to show
End If
End Sub

thanks,
dan

[mvidas]

Djblois,
Private Sub MultiPage1_Change()
With MultiPage1
If .SelectedItem.Name = .Pages(.Pages.Count - 1).Name Then
Me.Hide
UserForm2.Show
End If
End With
End SubShould do it!
Matt

[mvidas]

Sorry Dansam, didn't refresh :)

[Djblois]

that worked guys thank you