View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default TabSritp & Multipage

Waht is the different between TabStrip and Multipage?. When do I know
which
one to use?..


A Multipage is a "container" object, like a Frame. You can place other
controls on each page and the control's parent is the multipage.

A Tab strip can be made to look like a MultiPage but placing other controls
on it merely places them over it, you can't have separate controls per tab
(though you might toggle their visibility depending on the selected tab).

I have a form with two pages. Each page has label, Textbox, and OK button.
However, I do not know how to setup the code to allow the following:
1.- When click "Page 1" run the "macro 1"
1.- When click "Page 2" run the "macro 2"


Put a MultiPage and a Tabstrip on a userform

Private Sub MultiPage1_Change()
With MultiPage1
Me.Caption = .Value & " " & .Pages(.Value).Name
End With
End Sub

Private Sub TabStrip1_Change()
With TabStrip1
Me.Caption = .Value & " " & .Tabs(.Value).Name
End With
End Sub

Regards,
Peter T