Entries of ComboBox with Color

P

pallaver

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
 
P

pallaver

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
 
Top