VBA to alter selection in a Drop Down Box
 

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!

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!