Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Possible to colour seperate lines in a list box?
Greetings,
I'm just wondering if it's possible to colour different lines within a list box? I want to do the following First line - white Second line - light blue Third line - white Fourth line - light blue and so on. Just wondering if this is possible? Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Possible to colour seperate lines in a list box?
That option is not included in the Properties list for a ListBox. You do
have the option to use bold or italics but it applies to the entire list, not single lines. "NateBuckley" wrote: Greetings, I'm just wondering if it's possible to colour different lines within a list box? I want to do the following First line - white Second line - light blue Third line - white Fourth line - light blue and so on. Just wondering if this is possible? Thanks in advance for any help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Possible to colour seperate lines in a list box?
You might check out this link:
http://www.andypope.info/vba/colourdropdown.htm Hope this helps, Hutch "NateBuckley" wrote: Greetings, I'm just wondering if it's possible to colour different lines within a list box? I want to do the following First line - white Second line - light blue Third line - white Fourth line - light blue and so on. Just wondering if this is possible? Thanks in advance for any help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to colour seperate lines in a list box?
Did you not see my reply to your similar question under subject:
"ListBoxes - Different Elements, different colours" on 25 March. Regards, Peter T "NateBuckley" wrote in message ... Greetings, I'm just wondering if it's possible to colour different lines within a list box? I want to do the following First line - white Second line - light blue Third line - white Fourth line - light blue and so on. Just wondering if this is possible? Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a text box and cannot use the Enter key to seperate lines | Excel Worksheet Functions | |||
seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
How to draw lines to seperate data | Excel Programming | |||
How to draw lines to seperate data | Excel Programming | |||
How to draw lines to seperate data | Excel Programming |