As far as controls go, all the objects that you would access from the
Forms command bar are hidden, since they have been made obsolete (or
so it is said) by the ActiveX controls on the Controls command bar. If
you view the Worksheet object, you'll see that it has a (hidden)
DropDowns function that returns the dropdowns on that sheet.

Is there a way to know - from the Object Browser - that Sheets are
instances of Worksheet?

Sheets < Worksheets. Sheets include Worksheets, but also Chart
Sheets, Module Sheets (obsolete) and Macro Sheets (obsolete).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 17 Feb 2009 14:31:03 -0800 (PST),
"
wrote:

Showing hidden members a good tip. Is there a criteria for what's
hidden and what's not?

How would I find that Sheets has a DropDowns collection and that
DropDown has a ListIndex property?

Showing hidden members made it so I saw results when searching on
DropDowns.

But it didn't make it so that I could see DropDowns is a member of
Sheets.

I discovered that DropDowns is a member of Worksheets though.

Is there a way to know - from the Object Browser - that Sheets are
instances of Worksheet?

Or could I work backwards and from DropDown see that it would be a
member of a Sheets object?

Any ideas on this one?


Thanks.