No, you can't change colors or fonts within a list box. A listbox
can have only one font.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"christopher ward"
wrote in message
...
dear experts - first if you reply thanks in advance i
appreciate the help
ok - i have a vba system that uses a number of forms with many
list boxs and
my question is can items be colour coded in a list box for
example first 20
items in blue , next 20 in red - or can a different font be
used
this is for my end user as an aid when woking with the list
box's
i hav no idea how to do this - can it be done using standard
vba list box ??
--
C Ward