Hello Ben,

You can display any item in list by setting the ListIndex property.

EXAMPLE:

Shapes("Drop Down 11").ControlFormat.ListIndex = 1

This displays the first item in the list. The numbering begins at 1.

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=487543