Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is it possible,when selecting an item from a combo box list, which is
linked to another sheet,to have the font color or style change,depending on the selection? |
#2
![]() |
|||
|
|||
![]()
If you go into design mode, and right click on that combobox (from the control
toolbox toolbar), you'll see a property called .forecolor. There's also a .font property you can access. You can change it with something like: Option Explicit Private Sub ComboBox1_Change() Dim myColor As Long Dim myBold As Boolean With Me.ComboBox1 Select Case .ListIndex Case Is = 0: myColor = RGB(255, 0, 0) myBold = False Case Is = 1: myColor = RGB(0, 255, 0) myBold = True Case Is = 2: myColor = RGB(0, 0, 255) myBold = True Case Else myColor = RGB(0, 0, 0) myBold = False End Select .ForeColor = myColor .Font.Bold = myBold End With End Sub This does change the colors/font in the dropdown, too. "robert inman via OfficeKB.com" wrote: Is it possible,when selecting an item from a combo box list, which is linked to another sheet,to have the font color or style change,depending on the selection? -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Dave I really appreciate your timely response. Only I don,t think I was
clear as to my problem. Is there any way to make the font style and/or color change from item to item within the same list, in the same combo box. If so please help. Again I thank you for your support. -- Message posted via http://www.officekb.com |
#4
![]() |
|||
|
|||
![]()
Each option has a different font? Not within anything that's built into excel.
Sorry, "robert inman via OfficeKB.com" wrote: Dave I really appreciate your timely response. Only I don,t think I was clear as to my problem. Is there any way to make the font style and/or color change from item to item within the same list, in the same combo box. If so please help. Again I thank you for your support. -- Message posted via http://www.officekb.com -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo box list question | Excel Discussion (Misc queries) | |||
List box or combo box on an Excel spreadshee... | Excel Worksheet Functions | |||
dependent combo box list, with indirect reference | Excel Discussion (Misc queries) | |||
Combo box list depends on value | Excel Discussion (Misc queries) | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) |