Data Validation - Excel 2007
 

Hi:

Can anyone tell me if there is a way to change the font size in a data
validation drop down list in Excel 2007. Font is very small.

Thanks,

Data Validation - Excel 2007
 

On Feb 23, 4:10*pm, Theresa wrote:
Hi:

Can anyone tell me if there is a way to change the font size in a data
validation drop down list in Excel 2007. *Font is very small.

Thanks,

It is not possible. A very popular way to see the list better is to
increase the zoom view when the data validation is selected, this is
done with vba.
If The Data Validation list is in A1 then this code will increase the
zoom when A1 is selected.
Right click on the sheet tab and select view code. Copy and Paste the
code there

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

ActiveWindow.Zoom = 100

If Target.Address = "$A$1" Then ActiveWindow.Zoom = 200


End Sub