View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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