ListBox Font & Font Size & Font Color Changes for Excel
Posted on 2002-05-15
I have a spreadsheet, in which, I been asked to add some automations.
I would like to have a Listbox with some standard processing options on the main spreadsheet. I can format font for command buttons with a right click and click Format Control, on the Font Tab. But when I right click and click Format Control with a Listbox the Font Tab is missing ( same for ComboBox ).
I add items to the Listbox via VBA in the "Auto_Open" for the spreadsheet. But the Font Size is way too small. Plus I would like to change color to indicate conditions of operations.
I been through the helps, search this forum, some research in a search engine, look through the Object browser and can not find a work around for changing font parameters on a Listbox on top of a spreadsheet.
Thanks for your support & interest, P1