Specifying a result for a Drop Down Box
 

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 ***

Specifying a result for a Drop Down Box
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darin Kramer" wrote in message
...

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 ***

Specifying a result for a Drop Down Box
 

:)

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