Drowdown menu reset

[Rasmus]

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

 

[Frank Kabel]

Hi
set the listelement property to '-1'

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

Dropdowns from the forms toolbar use zero rather than -1 for this.

 

[Frank Kabel]

Hi Tom
thanks for the correction.

 

[Rasmus]

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

Thanks for your answers guys. However this one gices me the message:

'Unable to get the DropDowns property of this Worksheet class' ?

Rasmus

 

[Rasmus]

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

Thanks for your answers guys. However this one gices me the message:

'Unable to get the DropDowns property of this Worksheet class' ?

Rasmus

 

[Tom Ogilvy]

for me, with a dropdown from the forms toolbar named DropDown164, it clears
the selection - as you asked:

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

If you chose some goofy name for an activeX Combobox, then perhaps you want

Activesheet.OleObjects("DropDown164").Object.ListIndex = -1

We can only guess at what type of control you are working with. Maybe you
really are using a CommandbarCombobox control (since you said dropdown
menu), but that certainly wouldn't be in the shapes collection.