Userform listbox font color

[Ken Warthen]

I have a multicolumn listbox on a userform in an Excel 2007 spreadsheet that
populates store numbers and group names based on a group name selected from a
combobox. All the information is obtained from named ranges on a worksheet.
I would like to have the listbox display the store numbers of new stores
(from another column on the worksheet where values are "Yes" or "No") in a
different font color than stores that are not new. Is this possible?

TIA,

Ken

 

[jamescox]

Most everything is possible if you don't mind bullying the electrons
around - and the learning curve on how to do so...

There is an OCX called a listview that might be able to do what you
want, if you want it badly enough.

Take a look at

'Listview vs Listbox [Archive] - DevX.com Forums'
(http://forums.devx.com/archive/index.php/t-68506.html)

'Daily Dose of Excel Blog Archive ListView'
(http://www.dailydoseofexcel.com/archives/2006/12/26/listview/)

as starting points.

Really, really good luck on this - and if you dig through it, please
post a version here... :Bgr

 

[Ken Warthen]

I've used listview controls in other applications where such functionality
was available. In this particular project I'll be limited to native Excel
controls. Thanks for the input though.

Ken