Waht is the different between TabStrip and Multipage?. When do I know which
one to use?..
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"

Could you please help me with this code?

Thanks in advance.
Maperalia

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

Peter;
Thanks for your quick response.
According to the information you just gave me. Mlutipages is the more
suitable for me. I copied the code to use this form. Correct me if I wrong, I
understood that since I have two pages I will use the following:

'###Start of 1st Page ###################
Private Sub MultiPage1_Change()
With MultiPage1
Me.Caption = .Value & " " & .Pages(.Value).Name
End With
End Sub
'#### End of 1st Page ###################

'### Start of 2nd Page ###################
Private Sub MultiPage2_Change()
With MultiPage1
Me.Caption = .Value & " " & .Pages(.Value).Name
End With
End Sub
'#### End of 2nd Page ##################


In addition, could yiou please tell me what statement I need to write in my
module to recognize this form?

Thanks.
Maperalia










"Peter T" wrote:

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

I guess(?) you mean you have one Multipage control, named "MultiPage1",
which has two pages. Your concept is wrong, you trap events for the entire
MultiPage, not individual pages. The code I gave you will tell you which
page the user has selected, if indeed you actually need to know that. So

Note the current page is indicated by the MultiPage's Value property, the
first page has value 0, the second page is 1, etc

Normally you will place additional controls on each page and trap their
events as needed.

In addition, could yiou please tell me what statement I need to write in
my
module to recognize this form?

I don't follow this, what do you want to "recognize", where from and when.

Regards,
Peter T


"Maperalia" wrote in message
...
Peter;
Thanks for your quick response.
According to the information you just gave me. Mlutipages is the more
suitable for me. I copied the code to use this form. Correct me if I
wrong, I
understood that since I have two pages I will use the following:

'###Start of 1st Page ###################
Private Sub MultiPage1_Change()
With MultiPage1
Me.Caption = .Value & " " & .Pages(.Value).Name
End With
End Sub
'#### End of 1st Page ###################

'### Start of 2nd Page ###################
Private Sub MultiPage2_Change()
With MultiPage1
Me.Caption = .Value & " " & .Pages(.Value).Name
End With
End Sub
'#### End of 2nd Page ##################


In addition, could yiou please tell me what statement I need to write in
my
module to recognize this form?

Thanks.
Maperalia










"Peter T" wrote:

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