Lables that Change with Names for Games...
 

Is there a way that you can make a UserForm Lable change the captio
when selected values in a ComboBox are selected

Lables that Change with Names for Games...
 

Try this.........

Private Sub ComboBox1_Change()
Dim msgtext As String
Select Case ComboBox1.ListIndex
Case Is = 0: msgtext = "Text 0"
Case Is = 1: msgtext = "Text 1"
Case Is = 2: msgtext = "Text 2"

End Select
Label1.Caption = msgtext
End Sub



--
Cheers
Nigel



"Adeptus - ExcelForums.com" wrote
in message ...
Is there a way that you can make a UserForm Lable change the caption
when selected values in a ComboBox are selected?