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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darin Kramer" <[email protected]> wrote in message
news:[email protected]...
>
> 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 ***

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