I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?

I have tried changing the font size on the sheet itself & changing the font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the page.

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

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

Ryan wrote:
I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?

I have tried changing the font size on the sheet itself & changing the font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the page.


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

Ryan, you can not change the font size in the drop down list but have a look
here for a work around

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ryan" wrote in message
...
I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?

I have tried changing the font size on the sheet itself & changing the
font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the
page.