Specifying a result for a Drop Down Box

[Darin Kramer]

Hi There,

I would like to create some VBA that changes the result for a drop down
to a result of 2. (There are only two options Yes (1) and No (2)

I know how to select the Drop down...
ActiveSheet.Shapes("Drop Down 2").Select

but how do I force it to choose option 2...?

Thanks and Kind Regards

Darin


*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

activesheet.dropdowns("Drop Down 2").value = 2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Darin Kramer]

*** Sent via Developersdex http://www.developersdex.com ***