I would bet that the dropdown isn't named "drop down 1".

If you select it and look in the name box (to the left of the formula bar),
you'll see the name.



cmpcwil2 wrote:

Hi, thanks for the reply but it doesn't work for me.
I get the following error:
unable to get the DropDowns property of the worksheet class

Also when I try and replace DropDown with ComboBox I get the following
error:
object doesn't support this property or method.

--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=534463

--

Dave Peterson