Multipage programming

[John Flynn]

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

 

[Chip Pearson]

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

 

[Guest]

Chip,
This selected the TAB but for me it does not repaint the
multipage and show the items within the pages associated
with the TABS. The controls associated with the first page
of the multipage are the only ones shown. What am I doing
wrong? Excel XP

 

[stu]

-----Original Message-----
Chip,
This selected the TAB but for me it does not repaint the
multipage and show the items within the pages associated
with the TABS. The controls associated with the first page
of the multipage are the only ones shown. What am I doing
wrong? Excel XP
each
.