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.ListI ndex = -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.

--
Regards,
Tom Ogilvy


"Rasmus" wrote in message
.cable.rogers.com...
"Tom Ogilvy" skrev i en meddelelse
...
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