View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Drowdown menu reset

Activesheet.Dropdowns("DropDown164").Listindex = 0

--
Regards,
Tom Ogilvy


"Rasmus" wrote in message
t.cable.rogers.com...
What is the command for resetting dropdown menus ?

Ie.
Application.Shapes("dropdown164")... if I want it to be 'reset' to the

first
line in the dropdownmenu after a change ?

Rasmus