Data Validation - Excel 2007

T

Theresa

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,
 
C

CurlyDave

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,
Click to expand...

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
 

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

Validation Font Size varies 3
Data Validation text size 4
get Data Validation to stop, list supplied, duplicate data entries 1
data lookup/validation syntax 2
Conditional Validation In Excel 1
Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change pro 1
Hide column based on data validation 0
Excel 2010/2007 - How much can be done with Custom Validation? 6

Top