Userform listbox font color

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
 
J

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top