Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Chart Data Lables size | Charts and Charting in Excel | |||
print lables from excel names and address list | Excel Discussion (Misc queries) | |||
Games | Excel Discussion (Misc queries) | |||
Change names of files in a folder to match names in Excel Column | Excel Programming | |||
More games than work | Excel Programming |