Properties

These are the quantifiable characteristics of an object.
You can find out whether an exception will be generated by looking in the object model documentation.
Property values can be Numerical, String or Boolean and they may be specific or apply to several objects.
They can be obtained or set by assignment statements.
You can easily use the NOT operator to toggle properties on or off. (eg ActiveWindow.DisplayAlerts = NOT ActiveWindow.DisplayAlerts).

Declarations

Also known as property procedures.

Property Get - used to retrieve a property of a class. Get the value of scalar of object property.
Lets you return a property value or property reference
Take action before retrieving
Return a calculated value

Property Let - used to assign the value to a property of a class. Set the value of scalar property.
Lets you define a new property value
Take action after setting
Perform data validation

Property Set - used to assign an object to a property of a class. Set a reference for object property.
Lets you define a new property reference

Property - Collection

Property - Object

Property - Date

Property - String

Property - Variant

Important

If you are using an Object data type then you must use Set instead of Let.