An object is an entity such as a workbook, worksheet or range (Like a
noun). In the object browser, objects will usually be refered to as a
class.
an object can have properties (attributes) (properties can themselves be
objects)
Workbook
Name
Worksheets
Worksheet
Name
UsedRange
parent <== also an object (workbook)
Range <== also an object
Range
address
Interior.colorIndex
Font.colorIndex
visually, a range has a background color and a font color. However, in the
object model, the range has an interior (object) which can have a color or
colorindex and the font can have a name, size, color, colorindex. The
reason these are objects is because other types of objects can also have
interiors and fonts. So this makes them reusable.
If the property is not read only, you can assign it a value
Activeworkbook.Worksheets("Sheet1"). Range("A1").Interior.ColorIndex = 3
' Makes the cell A1 red.
A method is like a verb, it performs an action
ActiveWorkbook.Worksheets.Add
adds a new worksheet the active workbook
A class is generally used to refer to a developer defined object that will
usually also have properties and methods created by the developer using a
class module. However, as was stated at the start, a more general view is
that class and object are interchangable.
I am sure others will have useful thoughts as well. Note that none of the
listings used are exhaustive, but are illustrative.
