How about using Data Validations (DataValidation). Loads of help on that.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stas" wrote in message
...
Hello all!
There is no help for this control: ActiveSheet.DropDowns
(Hidden Language Element. You have requested Help for a language element
that is hidden, and therefore unavailable for programmatic access. )
I need some documentation for this element, some methods, properties.
I need know returned value of dropdown.
Thanks.
Stas.