change the font and rows displayed on a validation list

[alexaronson]

Hello and thank you for looking at my question.

I have a validation list on a spreadsheet. However, to get the spreadsheet to fit on the screen, I have to zoom in to 60% which makes reading the values in the validation list inpossible to read while selecting them.

From what I read, there is no way to edit the standard validation list to include more rows or to change the font size.

However, several authors suggest fixing with VBA programming but they do not say how.

Any suggestions on how I can do this?

Thank you again for your help.

 

[Tom Urtis]

See if this helps:

For the worksheet where this is happening, left click on your sheet tab, and click to selct View Code. Copy the below code and paste it into the large white area that is the worksheet module. Press Alt+Q to return to the worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveWindow.Zoom = 60
If Target.Cells.Count > 1 Then Exit Sub
Dim dvCell As Variant
On Error Resume Next
dvCell = Target.Validation.Type
If Err.Number = 0 Then ActiveWindow.Zoom = 100
Err.Clear
End Sub