View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default which page is active

All you need is the index of the current page from the multipage value
property

Private Sub CommandButton1_Click()
Dim n As Long
Dim s As String

n = Me.MultiPage1.Value
s = Me.MultiPage1.Pages(n).Caption

MsgBox "Index " & n, , s

End Sub

Don't forget the index of the first page (Page1) is 0

Regards,
Peter T

"JT" wrote in message
...
How can I code an "if statement" to see which page in multipage form(4

pages)
has been selected? I want to do specific things if page4 is "active".
Thanks...
--
JT