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.