Font size for drop down validation list

[Terry]

When I am in 60% zoom (to see all my worksheet data) I
can't read the text on a validation drop-down list--the
font is too small. I have tried everything and can't
find how to change it. I also tried using "zoom
selection", but it make the validation box too big--full
screen. Any ideas?

Terry

 

[Terry]

Using selection zoom makes it too big and it forces the 8
people using the project files jump around between zooms
too much. Several are in their late 50's and aren't very
computer literate.

If I use 75% it is acceptalbe in the drop down list but
then they have to scroll around the screen too much. I
usually have to check their work so that means I have to
scroll around alot (over 100 worksheets and charts to
look at).
Thanks though.
Terry

-----Original Message-----
How about just using 100% (or 120%)?

You can select a range (say A1:x1) and then do

Zoom|Selection. This will adjust

 

[Dave Peterson]

Maybe you could use an event macro that changes the zoom based on your
selection:

Debra Dalgleish suggested a macro like this:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub

If Intersect(Target, Range("a1,b3,d9")) Is Nothing Then
ActiveWindow.Zoom = 60
Else
ActiveWindow.Zoom = 75
End If

End Sub

Right click on the worksheet tab that should have this behavior and select view
code. Paste this in.

Adjust the range addresses (a1, b3, d9) to match the cells with Data|Validation.