Wierdness on Excel Object Browser

  • Thread starter gimme_this_gimme_that
  • Start date
G

gimme_this_gimme_that

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

Sheets("Configuration").DropDowns("sg_database_dropdown").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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top