Although class modules aren't discussed extensively, this may provide what
you need to know:

From Chip Pearson's site:

http://www.cpearson.com/excel/codemods.htm
where to put your code

--
Regards,
Tom Ogilvy

Jeff Marshall wrote in message
...
Hi ,

Can someone please explain in laymen's terms the difference between the
two?

The advantage of a class module over a module ?

Is there any special requirements that a class module needs over a module?

Thanks for your help.
Jeff