How to Increase Font Size In Excel Drop-Down List Using VBA | Drop-Down List Font Too Small

Download the featured file here: www.bluepecant...
In this video I demonstrate how to increase the font size in an Excel drop-down list. Unfortunately Excel does not provide a way of changing the font size in a data validation drop-down list but you can automatically zoom in on the drop-down when selected.
Here's the code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo SetZoom
Dim ZoomAmt As Integer
ZoomAmt = 100
If Target.Validation.Type = 3 Then ZoomAmt = 300
SetZoom:
ActiveWindow.Zoom = ZoomAmt
End Sub
------------------------

[@rodayers9126]

I downloaded the file, ran a test. The cell containg the drop-down list zoomed as expected, but the values in the list were not zoomed.

[@bhar2855]

It doesn't work for me either. I had a code that was similar in function to this one and it used to actually make the menu choices bigger. I had had a screenshot one time doing a comparison. Then we upgraded to Excel 365 and I just recently noticed it doesn't work anymore. It zooms the cell, but the drop-down menu's font is still the same whether the code is there or absent. Do you have Excel 365 as well?

[@marcoscastrodeoliveira901]

Thanks for help! Great!

[@crombajaa]

Thank you for this. Is there a way to combine this code and your select Multiple Items From Drop Down List together?
Any help is appreciated. Thanks!

[@tomekbzdyra8717]

Thank you! You solved my problem.

[@alexanderdanielsarno382]

Thanks man! Big help

[@yosb961]

cool man, thank you !!!!

[@ChesterTugwell]

Happy to help!

[@alexrosen8762]

Superuseful 👌

[@IvanCortinas_ES]

What's the meaning of Target.Validation.Type = 3??
It doesn't matter if you type Yes or No. The behavior is the same, it's a toggle behavior.

[@9460016928]

Good morning sir,
It's work good .👍