Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So looking at the archives, it seems like only the entire line entry
to a ComboBox can have it's color changed. I'm trying to entire in "TEMP ”" where the square block after temp is either red or blue... Is there a way to have it be red or blue within the ComboBox? Is a case select method the only way to input colors into the line entries of a ComboBox? Anybody have example code for that they could copy/paste for me to use/modify? Thanks, np |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For those curious:
This is what I've got right now to at least let the user know which color the square is on the excel spreedsheet. Ideally I'd like it to read TEMP in black, with a red square next to it, but the possibility of that is looking... grim. ----------------- If Sheets("Sheet1").Cells(ItemRow, ItemColumn + 1).Font.ColorIndex = 5 Then CurrentItemAdditionalInfo = Trim(CurrentItemAdditionalInfo) + "(BLUE)" End If If Sheets("Sheet1").Cells(ItemRow, ItemColumn + 1).Font.ColorIndex = 3 Then CurrentItemAdditionalInfo = Trim(CurrentItemAdditionalInfo) + "(RED)" End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Counting entries by color code | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions |