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!

Activesheet.DropDowns("Drop Down 810").ListIndex = 1

--
Regards,
Tom Ogilvy

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