How to find all the properties associated with an object

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

In VBA when you type something like Sheets and then a period you are given a
dropdown list of what can be associated with Sheets.
I have on many occassions had great help from many in this group that give
instances such as
"ActiveSheet.ShowAllData"
where typing in ActiveSheet and the period reveals no such list.
Is there somewhere or somehow a method that I can get the full (or fullish)
list where the objects' properties are not given?
Rob
 
rob nobel said:
where typing in ActiveSheet and the period reveals no such list.
Click to expand...

This one is a mystery. A guess: ActiveSheet could be either a worksheet, a
chart sheet or an XLM macro sheet, in which case it's uncertain which set of
properties would pertain to ActiveSheet.
Is there somewhere or somehow a method that I can get the full (or fullish)
list where the objects' properties are not given?
Click to expand...

VBA online help.
 
Hi Tornados. Maybe I don't understand the object browser as I can't seem to
get what I need from that. As an example, I entered ActiveSheet and
ShowAllData does not appear in the list.
However it does come in the list if I search for WorkSheet. This is
confusing to me as I'm left wondering still what properties (or as the
object browser puts it: "Members") go with which object (or "class"). A
search for ActiveSheet brings up no further properties associated with it,
just that it's a member of Application, Window or Workbook.
But I want what is associated with ActiveSheet. (ie ActiveSheet being the
parent.)
I hope that's all clear.
Rob
 
But ActiveSheet can be a Chart sheet, a 4.0 macro sheet, a dialog sheet, an
international macro(?) sheet, and a worksheet.

So you'd have to use something more specific--worksheet.

You may want to consider a book so that you can read it in the, er, library:

I have John Green's (et al) book: Excel 2002 VBA Programmer's Reference.

In the back of that, there's a nice reference for excel's object model.

I have John Walkenbach's Excel 2000 Power Programming with VBA. I didn't see a
consolidated list in that, but John Walkenbach does cover it in each appropriate
chapter.

I'm still gonna say to visit your local book store and see what you like best.

But you may want to try here first:
http://msdn.microsoft.com/
 
Thanks Dave....and Also Harlan (I missed your post earlier).
You're right about the active sheet being a number of objects which would
preclude a definitive list.
I'm pretty sure that's not the only example and I suspect the "Buy a book"
suggestion will help me the best.
Thanks,
Rob
 
Back
Top