View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default which page is active

JT,

The Value property of the MultiPage control will return the index
number of the active tab. The index is zero-based, so the first
tab is Value = 0, the second page is Value = 1, etc. So you can
write code like

If Me.MultiPage1.Value = 3 Then
' fourth tab active
' do something
End If





--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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