ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Validation- Drop Down menu size (https://www.excelbanter.com/excel-discussion-misc-queries/69158-validation-drop-down-menu-size.html)

bras1l

Validation- Drop Down menu size
 

To see my entire document I have the zoom around 68%.
At this scale, my drop down validation menus are way too small to read
even though I can read all the other normal text.
How can I adjust the scale of the drop down box and its menu without
changing the zoom scale of the entire document?


--
bras1l
------------------------------------------------------------------------
bras1l's Profile: http://www.excelforum.com/member.php...o&userid=19486
View this thread: http://www.excelforum.com/showthread...hreadid=507871


Debra Dalgleish

Validation- Drop Down menu size
 
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

bras1l wrote:
To see my entire document I have the zoom around 68%.
At this scale, my drop down validation menus are way too small to read
even though I can read all the other normal text.
How can I adjust the scale of the drop down box and its menu without
changing the zoom scale of the entire document?




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


bras1l

Validation- Drop Down menu size
 

Thanks Debra,
I was hoping there was a way to do it without code which I am not good
at. I'll see what I can do. Thanks.


--
bras1l
------------------------------------------------------------------------
bras1l's Profile: http://www.excelforum.com/member.php...o&userid=19486
View this thread: http://www.excelforum.com/showthread...hreadid=507871



All times are GMT +1. The time now is 04:48 PM.

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