Class modules using VBA in Microsoft Excel 2010

A class is the formal definition of an object. The class is a template for the creation of the object during programming,
and defines the properties and methods that decides how the object behaves. Class modules is new in Office97.
With class modules it's possible to create your own objects. These objects can have properties and methods like
the built-in objects, and you can create several copies of an object if you need to.
Programmers have managed without class modules earlier, and the reason for using class modules
may not become obvious before you have used class modules for a while. Here are some of the
advantages when using class modules :

  • Class modules makes it possible to separate complicated source code for advanced processes.
    This makes it easier for other to use the source code without understanding how the process is performed.
  • Class modules makes the development of complicated tasks easier by breaking up the code in smaller
    and easier manageable parts. This has been possible earlier, but a class module forces you to separate
    the code from the ordinary procedures, resulting in a more obvious function separation.
  • Class modules let you create reusable components. Because of the obvious separation between
    classes and the procedures using them, the classes contains independent code components that
    can easily be shared between different projects.
  • Class module sis the foundation of other component technologies, Visual Basic can be used to
    create X Automation servers and ActiveX controls.

When to use class modules

Here are some examples on when you would want to use class modules :

  • Database management
    Class modules makes it easier to create objects that can manage a database with VBA. You can
    create a class that contains code for reading or writing to a database table.
    This class can be used in your macro without the user knowing how and where the data comes from.
  • Wrapping in API procedures
    Class modules makes it easier to use Windows API-functions in your macros.
    Wrapping the API-functions in a class module makes the development easier for people that are not
    that familiar with the more complicated function in Windows.
  • Managing reading and writing to text files
    This is really not that complicated, but who goes around and remember how this is done in VBA?
    By creating a class that manage low level reading to and writing from a text file, the properties
    and methods in the class can easily be used in your macros.

Class modules can also be used to simplify Registry management, and to create new properties and
methods to objects in the applications.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.