This page from Debra Dalgleish's web site might help:

http://www.contextures.com/xlDataVal08.html#Font
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bruce Edwards" wrote in message
...
I am using data validation to check data input against a list in a work
sheet
but the text in the dropdown box is size 8 and too small to read. Standard
format for the work book is size 12. How can i change the text size in the
drop down box to size 12