| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make list of Items displayed in AutoFilter? Any Function? | Excel Worksheet Functions | |||
| Need to make a drop down list of 3 items that input a value in ano | New Users to Excel | |||
| How to make the items in Drop Down List appear as workable hyperli | Excel Worksheet Functions | |||
| i want to delete duplicate items in a list using code. | Excel Programming | |||
| How do I color code items in a drop down list? | Excel Discussion (Misc queries) | |||
Linear Mode
