Validation-Tiny List Items??

[Jennifer]

(please reply via email)

Does anyone else have this problem? I have a validation
list, and when an item is selected from the drop-down
list, the formatting is fine. However, when viewing the
actual drop-down list, the font of the list items is TINY.
I have to blow the worksheet up in order to be able to
make a selection. Is there a way to format the items in
the list? (Not the target cell...that is fine.)

Thanks in advance.
Jennifer

 

[Debra Dalgleish]

You can't change the font in Data Validation dropdowns. You can use an
event procedure to increase the zoom setting when the cell is selected,
but the effect can be very jumpy.

In the following code, cell C4 has a dropdown list. Change the cell
reference from $C$4 to match your worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$C$4" Then
ActiveWindow.Zoom = 150
Else
ActiveWindow.Zoom = 100
End If
End Sub

To add this code to the worksheet, right-click on the sheet tab, and
choose View Code. Copy the code, and paste it onto the code module.