Wierdness on Excel Object Browser
 

Right-click in the Object Browser and choose "Show Hidden Members"
from the pop-up menu.

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 12:48:42 -0800 (PST),
"
wrote:

After some research today I discovered how to fetch the list index of
a dropdown:

Sheets("Configuration").DropDowns("sg_database_dr opdown").ListIndex

At first I didn't know what exactly I was looking for - since I was
searching for ComboBox not DropDowns.

But anyway, I'm puzzled why I couldn't go into the Object Browser,
search over all Libraries , enter Sheets, and then get DropDowns in
the Member-of window.

After that I searched for DropDown and the DropDown object didn't
appear.

I was able to find what I needed by searching the internet.

But is there a trick to using the Object Browser that I'm not seeing?

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

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

Thanks.

Wierdness on Excel Object Browser
 

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.

Wierdness on Excel Object Browser
 

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.