dropdown

[Stas]

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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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.

 

[JE McGimpsey]

Data/Validation has nothing to do with the DropDowns collection.

DropDowns refers to the collection of Forms ComboBoxes.

 

[Bob Phillips]

I am suggesting an alternative!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[JE McGimpsey]

I am suggesting an alternative!

Ah, missed that - I use them for very different purposes (especially
since DropDowns don't get overwritten by pasting, and can be linked to
cells other than where they appear), so I never think of substituting
one for the other.