What is the difference between class and module in VB net? *Inheritance is using an existing class to build a new class. Let's start this post by looking at why we useobjects in the first place. The purpose of VBA Class Modules is to allow us to custom build our ownobjects. In VBA we have built-in objects such as theCollection, Workbook, Worksheet and so on.

Subsequently, question is, what is the use of class module in VBA? A class can be so much more - itcan hold its state (by keeping track of instance variables) and beduplicated as many times as you want. A module will never be anything otherthan a library of methods. Secondly, what is difference class and module? The Difference Between a Class and a Module Basically, a class can be instantiated but a module cannot.

However the main difference between class moduleand standard module is that in standard module u canuse directly all the procedures and functions as long as it wasdeclared public while in class module u must first create anobject of the class and then set its properties and theninvoke its methods. These are similar to form modules, except theyhave no visible user interface.įurthermore, what is the difference between module and class module in VBA? You candefine the methods and properties for them and even write eventhandlers. Class modules are a special type of modulethat allow you to create your own customised objects.

Class module in excel vba examples