ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you control the font size of the data validation field? (https://www.excelbanter.com/excel-discussion-misc-queries/63393-how-do-you-control-font-size-data-validation-field.html)

jeffwamp

How do you control the font size of the data validation field?
 
How do you change the font size of text in the data validation drop down box.
The size of the data in the drop down box is effected by the zoom setting of
the spreadsheet. So, if you have the spreadsheet at anything less than a
100% the size of the text in the field becomes smaller and at 50% nearly
unreadable. Can you control the size of the font?

Dave Peterson

How do you control the font size of the data validation field?
 
Debra Dalgleish has a workaround:
http://contextures.com/xlDataVal08.html#Larger

jeffwamp wrote:

How do you change the font size of text in the data validation drop down box.
The size of the data in the drop down box is effected by the zoom setting of
the spreadsheet. So, if you have the spreadsheet at anything less than a
100% the size of the text in the field becomes smaller and at 50% nearly
unreadable. Can you control the size of the font?


--

Dave Peterson


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com