Functions vs Class module
From my experience, you want to use a class module when you want to create
multiple seperate instances of the object, which each have their own data.
An example my be a class module for building SQL statements. You could have
methods for adding clauses (right term?) to the statement, and a property
get to retrive the whole statement. To use it you would create an instance
of the class whenever you wanted to build a statement, and then destroy it
when finished. If this had been implemented in a standard module, then you
could only create one SQL statement at a time, and you would have to
remember to reset the module when finished.
You should use a module when you want to functions that are globally
accesible throughout the project, and don't need data to persist between
different calls. An example for this might be a routine that formats a form,
making different types of controls different colours. This would be called
in the form_load event, with a reference passed to the form as an argument.
Hope this helps,
Chris Key
