It can't.
Debra Dalgleish makes the following suggestion on her site ... One
workaround is to use programming, and a combo box from the Control Toolbox,
to overlay the cell with data validation. If the user double-clicks on a
data validation cell, the combobox appears, and they can choose from it.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"abcdexcel" wrote
in message ...
Hi
How could the font & size of the validation list box changed.
Regards
SAS
--
abcdexcel
------------------------------------------------------------------------
abcdexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30021
View this thread: http://www.excelforum.com/showthread...hreadid=498973