Thread: 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

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" <christopherward@discussions.microsoft.com>
wrote in message
news:535DF9C9-9C6C-4273-B4A3-36D4AA1C7F18@microsoft.com...
> 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

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" <christopherward@discussions.microsoft.com>
> wrote in message
> news:535DF9C9-9C6C-4273-B4A3-36D4AA1C7F18@microsoft.com...
> > 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
>
>
>