Drop Down List Font Size Workaround

[nirvehex]

Hello,

I keep my worksheet zoomed at 60% for proper viewing which causes my drop downs to look tiny! Is there any VBA code or a workaround that can possible increase the font size in specific drop down? I currently have a form control box called "Drop Down 4" which is the one I'm looking to increase the font size in.

Any ideas?

Thanks!

 

[Colo]

Hello nirvehex,

I've seen same questions but as far as I know, there is no way to increase the font size of in a drop down. All waht i know is that zoom the worksheet 200% then make all the font size in the worksheet small so that it LOOKS LIKE the font size in a drop down is increased.

 

[Taul]

There some workarounds here
http://www.contextures.com/xlDataVal08.html

I can't say how good they are as I have never used the workarounds, I would generally play with the worksheet zoom to get the result I need