Thread: VBA to alter selection in a Drop Down Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default VBA to alter selection in a Drop Down Box
Activesheet.DropDowns("Drop Down 810").ListIndex = 1

--
Regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...
Howdie.

I need to write a macro which selects an existing dropdown box (Drop
Down 810) and irrespective of the current selection, changes the
selection on it to the first option. It currently has three options.

Any ideas of what the VBA would look like would be most appreciated

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Reply With QuoteReply With Quote