How do I increase the font size in a cell validation list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to increase the font size in a cell validation list? To make
it work now, I have to raise the % on the sheet view to where I can't see
much of the sheet.

Thanks in advance
 
How about pasting this code into the appropriate sheet of the VB Editor. It
some code from Chip Pearson that zooms in when a particular cell is selected,
in this case A2

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