Class Modules vs Modules

[Jeff Marshall]

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

 

[Tom Ogilvy]

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

 

[Chip Pearson]

Jeff,

The short answer is that if you have to ask the difference between modules
and class modules, don't use class modules. Put all your code in standard
modules.

The longer answer is that you use class modules to create your own objects.
Objects are defined by their properties, methods, and events -- all of which
are placed in the class module -- and then defined in to existence with the
Set New syntax. If you are familiar with Type variables (called Structures
or Structs in other programming languages), you can think of a class as a
"Type With Code". You use Property Let/Get/Set statements to define the
properties (variables) of the class, and then add code with Subs and
Functions. Once you've defined all the properties and methods in the class
module, you create an object variable (or "instance") of that class with
code like

Dim X As Class1
Set X = New Class1

A full discussion of how (and when) to use classes is beyond the scope of a
newsgroup post. A good book on VBA should provide at least the basics.

 

[pfsardella]

Jeff,

I found the following links helpful in trying to understand class
modules.

http://www.microsoft.com/officedev/index/classmod.htm
http://msdn.microsoft.com/library/d...-us/odeopg/html/deovrcustomclassesobjects.asp

HTH
Paul