View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default ListBoxes - Different Elements, different colours.

There's nothing built in but Andy Pope shows a way to do it, clever stuff!

http://www.andypope.info/vba/colourdropdown.htm

Regards,
Peter T

"NateBuckley" wrote in message
...
Greetings I'm just wondering if anyone can help me out with an issue on

List
Boxes.

Here is an example

Billy
Timmy
Bob
Shane

These are 4 different elements within the List Box, If Timmy has recieved

a
low mark I want the text or simply the background of that element only, to
turn an orange. Is customisation of the elements possible like this?

Thank you in advance.