Small Font on Dada Valdation List

[leydorfs]

Thanks for taking my question.

I have a data validation list in an excel file. The font in illegable in the pick list that comes up since it is so small. Any idea why the font is displayed so small in the pick list. It is not small in the cells thatthe list is coming from... and -- more importantly -- how I can fix it.

Thanks.

 

[JamesW]

Hi,

You can't change the font size on a data validation list.

The only thing that makes it appear small is the zoom factor - the more you zoom out, the smaller the text becomes.

You could use something like this though:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
  If Target.Address  = "$A$2" Then 
    ActiveWindow.Zoom = 120 
  Else 
    ActiveWindow.Zoom = 100 
  End If
End Sub

(untested)