View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson[_2_] Chip Pearson[_2_] is offline
external usenet poster
 
Posts: 95
Default Multipage programming

John,

Use the Value property of the Multipage. A Value of 0 is the first page, 1
is the second page, and so on. E.g.,


Private Sub btnBack_Click()
With Me.MultiPage1
If .Value 0 Then
.Value = .Value - 1
End If
End With
End Sub

Private Sub btnNext_Click()
With Me.MultiPage1
If .Value < .Pages.Count - 1 Then
.Value = .Value + 1
End If
End With
End Sub


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



"John Flynn" wrote in message
...
How do I nagigate between pages in a multipage control?

I have a primary multipage control with 5 tabs and each of
these has a multipage control with multiple tabs.

I am trying to setup a "Next" "Previous" method of
navigating -- like a wizard.

Thanks