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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increase font size in Drop-Down List 1
Data Validation List: Text Size Query 2
validation List Size 1
Data Validation/In-Cell Dropdown Lists 1
Number in cell increase with increase in font size. 2
Font Size in Data Validation Drop Down List 1
Font size in data validation drop down lists 2
Increase font size in a check box 4

Back
Top