View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default 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.