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

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

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

-----Original Message-----
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


.

-----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

-----Original Message-----
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


.

.