Solved: Data Validation: Drop-Down Text Size

[Ken1000]

Hi. I have Excel 2003. Is there a means via VBA of increasing the text size of the source choices that appear in the drop-down box (list of choices)?

I am not referring to increasing the actual text size on the sheet itself. Just the visual appearance of the scrollable items that show in the associated list.

What, if any, VBA code would manipulate or control this?

Thank you very much for your help.

Ken

[Bob Phillips]

See http://www.contextures.com/xlDataVal08.html#Larger

[Ken1000]

Thank you so much, XLD. Your reply was super fast and your link answer covers a great solution.

Consider this one solved, indeed.

Have a great day. :hi:

Ken

[lucas]

Ken, be sure to mark it solved using the thread tools at the top of the page.