View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
stu stu is offline
external usenet poster
 
Posts: 3
Default Multipage programming


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



.

.