Listbox Colour Control?

[Dave Punky]

Hi all,

I'm just bouncing for ideas here, but I basically need to find a way of using a ListBox look a bit prettier than it currently does. I am pulling information from an Access database into Excel and I need to display a large volume of information in an easy to read manner - the easiest of which is to change text colour based on the content of the records.

Normally I would use a ListView however the unit I am using does not have MSCOMCTL.OCX activated (and at this stage I cannot get around this). Unfortunately this means I can't use the ImageSet control either to add icons or anything like that to distinguish entries.

I know that the ListBox control doesn't natively have colour control over multiple lines but I was wondering if anyone had any ingenious ideas as to how to distinguish certain entries using a ListBox?

 

[mikerickson]

You might get some ideas from this

http://www.vbaexpress.com/forum/showthread.php?t=35563&highlight=listbox+lighlite

 

[RoryA]

Presuming there is a good reason why you can't use a worksheet, you might be able to adjust Andy's combobox example here.