PDA

View Full Version : Solved: Change font and/or size for validation list



protegeone
10-20-2005, 11:23 AM
As in the title: Is it possible somehow to change font and/or size for a validation list?
I'm using several validation lists and it is quite small. Once choice is made, it changes automatically when in the cell, but would be nice to see the choices bigger.

Thanks for any input.

Bob Phillips
10-20-2005, 12:03 PM
Not possible using Data Validation. A combo box, yes, DV, no.

Zack Barresse
10-21-2005, 10:18 AM
For some alternatives, check out MS MVP Debra Dalgleish's site ...

http://www.contextures.com/xlDataVal08.html#Font

protegeone
10-21-2005, 12:56 PM
Thanks for the tip, will check it out. => Done.

Excellent site and tips. Very tempting, but finally decided to stick with VL as I don't want to have macro in the worksheet, but stashed link for later use.

Thanks again.