Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Entries of ComboBox with Color

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Entries of ComboBox with Color

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
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
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
Combine Multiple Entries with differing amounts of entries Katie Excel Worksheet Functions 2 November 28th 07 09:53 PM
Conditional color formatting entries have wild color. John Geyer Excel Discussion (Misc queries) 0 February 24th 06 06:11 PM
Counting entries by color code Carmen Excel Discussion (Misc queries) 3 September 19th 05 09:45 PM
How do I change multi-line entries to single line entries in Exce. CPOWEREQUIP Excel Worksheet Functions 3 April 14th 05 12:38 AM


All times are GMT +1. The time now is 12:28 AM.

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"