LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Chart Data Lables size Samaa Charts and Charting in Excel 1 March 28th 09 02:26 PM
print lables from excel names and address list moonraker Excel Discussion (Misc queries) 1 June 22nd 08 10:00 PM
Games Oliver Wainwright Excel Discussion (Misc queries) 1 November 15th 07 04:29 PM
Change names of files in a folder to match names in Excel Column saybut Excel Programming 4 February 9th 04 06:26 PM
More games than work Sammy Excel Programming 1 January 21st 04 03:29 AM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"