Reason for using Properies in Class Module?

[danny2000]

I can see situations where code examples for Excel Class Modules use Properties Let and Get statements when you could easily include those functions in a Method in the class module.

For example, I could use a Class.Method(with and argument) in a sub procedure when most examples will show a sub procedure referencing a class Method which calls the Property Let to do the same job?

I'm trying to understand this. Thanks
Danny2000

[Leith Ross]

Hello Danny2000,

Object properties are generally just variables. They can be numbers, strings or even objects. Methods are used to perform some action or actions on variables and objects which may or may not be a part of the Class object. Using only methods to set or return a value is particularly efficient. It is rather like swatting a fly with dictionary.

[danny2000]

That pretty much answers it. Thanks very much.