Objects, Properties and Methods

Hi, just joined and this is my first question.
I'm building myself a database to log the various bits of VBA codes that I've used in various macros so that when I think "Now how did I do that....?" I can quickly find the code / spreadsheet that I need. However, I'm a little confused about Objects, Properties and Methods. For example in the code:

Please Login or Register  to view this content.

what is the Object, Property and Method? Also, is there a "family tree showing how Properties and Methods etc are linked? I realise this is a two question thread but think they are linked bu apologoes if I should have asked two separate questions.

Regards


MODERATOR'S NOTE:
This thread was moved to the VBA forum as per forum rules.

Activesheet - object
.Range("A1") - Property of Activesheet
.Select - Method

you can not write Activesheet("Sheet1"), but Sheets("Sheet1"), Activesheet is the active Sheet at this moment

Well it can seem a little confusing, since a property can also be an object.

So what you actually have:

Please Login or Register  to view this content.

Application is an object
Worksheets is a property (a collection) of the Application Object that retrurns a Worksheet Object
Range is a property of the Worksheet Object that returns a Range Object
Select is a Method of the Range Object

No, as far as I am aware there is no "family tree", however, intellisense shows you the next level down, having the locals windows open when you step through code will show you your position in the tree down and finally the Object Browser lets you search through classes/objects to see their properties and methods

As well as the object browser there is the OM at MDSN
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

And the help qill also show methods/properties of objects

thanks for clarification, at the end my answer was wrong or not complete ?