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

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/arch...2/26/listview/)

as starting points.

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


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109676

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

"jamescox" wrote:


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/arch...2/26/listview/)

as starting points.

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


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109676