View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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?