List Box can you colour code items or make bold
 

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

List Box can you colour code items or make bold
 

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

List Box can you colour code items or make bold
 

thank you chip - a very fast response what a shame and surely a good feature
for m/soft to work on
--
C Ward


"Chip Pearson" wrote:

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