Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list selection | Excel Discussion (Misc queries) | |||
Drop Down Box Selection | Excel Discussion (Misc queries) | |||
Selection from drop-down box | Excel Discussion (Misc queries) | |||
Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
drop down selection determines other drop down content | Excel Discussion (Misc queries) |