What are Class Modules

[BizBoy]

Hi,

I am new to MS Access and have never used Class module in Excel VBA either.
My question is more regarding Access, can anyone please help me understand what are class modules.

How they are different from regular modules.
What are the advantages of a class module or why and when should we use it.

Can anyone please help me in this.

 

[xenou]

Class modules generally fit into an object oriented paradigm. You might create a class to represent an object that has many different attributes (perhaps something like a "Product" with attributes like Price, Size, ComponentList, ProductID, and Weight.

With a class you must instantiate the object before you can use it:
Dim my_object as new MyObject().

More explanation:
https://www.mrexcel.com/archive/vba/difference-between-module-and-class-module/

There are many tutorials online if you goodle VBA Class Module.

 

[BizBoy]

Hi xenou sir, thanks for the help. Have a nice day ahead.

 

[Micron]

Technically, the module behind a form or report is a class module. A standard module would be one that contains code but doesn't "belong" to any object, be that a form, report or custom object. A custom class not only can create an object and give it properties, it can also give the object methods.