Drop down box format
 

I have a drop down box that works fine but the font size is very small. Is
there a way to increase it w/o also increasing the overall size of the object
so that it's easier to see the list?

If you're talking about a...
Control Toolbox Combobox - yes, use the 'Font' property
Forms Combobox - no
Validation combo box - no
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Dan S" wrote:

I have a drop down box that works fine but the font size is very small. Is
there a way to increase it w/o also increasing the overall size of the object
so that it's easier to see the list?

If it's a data validation dropdown list, you can't change the font size.
There are a couple of workarounds he

http://www.contextures.com/xlDataVal08.html#Font

If it's a combobox from the Control toolbox, you can change the font
size by switching to Design view, opening the Properties window, and
changing the Font properties.

If it's a combobox from the Forms toolbar, you can't change the font size.


Dan S wrote:
I have a drop down box that works fine but the font size is very small. Is
there a way to increase it w/o also increasing the overall size of the object
so that it's easier to see the list?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html