I have gone to the VBA help files to try to find the difference and I am no better now than before.
A Class Module:
A module that contains the definition of a class, including its property and method definitions.
A Standard Module:
A module containing only procedure, type, and data declarations and definitions. Module-level declarations and definitions in a standard module are Public by default. A standard module is referred to as a code module in earlier versions of Visual Basic.
What is the purpose of a class module and when should it be created?
Bookmarks