View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default 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 ***