Userform listbox font color

  • Thread starter Thread starter Ken Warthen
  • Start date Start date
K

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
 
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
 
Back
Top