Hello Allan,

If you are referring to a Worksheet Data Validation in cell Drop Down
for a list then answer is no. None of its properties or methods are
exposed through VBA and are under Excel's control.

As a workaround, you could use Active X ComboBoxes instead. This would
give you the formatting control you want, but at the expense of
writting a lot of VBA code to make it work. Depending on how many you
intend use, this could quickly become an undesirable solution.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564162