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?


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=501243