Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a DLL to Excel (2003) Object Browser | Excel Programming | |||
Object Browser does what? | Excel Programming | |||
Object Browser Help | Excel Programming | |||
Object Browser Help | Excel Programming | |||
VBA Object Browser icons key | Excel Programming |