Class module & module in Excel

[airon]

Can anyone help me with better understanding the difference between a class module and a module in Excel VBA?

Thanks in advance,
Aaron

 

[RobBroekhuis]

For most purposes you only need a regular module. Use a class module when you need to define a self-contained reusable object class with its own methods, properties, and so on. Most processing of workbooks and worksheets is done perfectly well in regular modules. In my experience, class modules make more sense when trying to conveniently do things that are NOT offered as a standard within Excel, often interfacing with other applications or system components.
Rob