Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/11/Increase-Size-of-Drop-Down.zip

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
------------------------