dropdown
 

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.

dropdown
 

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.

dropdown
 

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

DropDowns refers to the collection of Forms ComboBoxes.

In article ,
"Bob Phillips" wrote:

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

dropdown
 

I am suggesting an alternative!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JE McGimpsey" wrote in message
...
Data/Validation has nothing to do with the DropDowns collection.

DropDowns refers to the collection of Forms ComboBoxes.

In article ,
"Bob Phillips" wrote:

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

dropdown
 

In article ,
"Bob Phillips" wrote:

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.