change label on multipage
Here is a generic example. You will need to change the object names as
needed.
This code belongs to your combobox_change event code.
Private Sub ComboBox1_Change()
If Me.ComboBox1.Value = "Groove Weld" Then
Me.Label1.Caption = "Groove Weld"
Else
Me.Label1.Caption = "Fillet Weld"
End If
End Sub
Mike F
wrote in message
oups.com...
I have a Userform with a Multipage on it. On the first page of the
Multipage I have a combobox. What I would like to do is based upon the
value of the combobox on the 1st page change the text of a label on
Page 2.
Is this possible, and if so how, I have tried to Code below but it does
not work.
If MultiPage1.Pages(0).cboTestType.Value = "Groove Weld" then
MultiPage1.Pages(1).lblWeldType.Caption = "Groove Weld"
else
MultiPage1.Pages(1).lblWeldType.Caption = "Fillet Weld"
End if
Regards
Martin
|