Change the font size in a Data Validation 1

[karpartz]

I am trying to change the font size in a data Validation list. The list is very small and hard to read. How do I change the size in Excels Data Validation drop down list to a larger font size using VBA. Is this possible?

 

[xlbo]

not possible - sorry

There is no font property of Data Validation so it cannot be changed

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

Change the entire set up of your sheet ... reduce font sizes, reduce column widths and row heights, and then increase the zoom magnification.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.