Data Validation text size

[statum]

Hello all, does anyone know how/if the font size of the listed data in a
validation drop-down box can be changed?

 

[Tom Hutchins]

It can't be changed directly, but Debra Dalgleish has a workaround using a
combobox on her Contextures site:

http://www.contextures.on.ca/xlDataVal10.html

Hope this helps,

Hutch

 

[statum]

Do you know if this has been corrected in Excel 2007?

 

[Debra Dalgleish]

There's no change to the Data Validation settings in Excel 2007. You
can't adjust the font size, and are still limited to 8 items visible in
the drop down list.

 

[statum]

Thanks. Boy, that's a poor design.

There's no change to the Data Validation settings in Excel 2007. You
can't adjust the font size, and are still limited to 8 items visible in
the drop down list.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com