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

 

[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