Class Module

[Evagrius Ponticus]

Hi,

What is the difference between a regular module and a class module? What can one do differently in a class module that can't be done in a normal module? Thanks,

 

[VoG]

Here is Colos's take on this http://puremis.net/excel/code/086.shtml

I must say that I've written a lot of code and never used a Class Module but don't let that discourage you

 

[Evagrius Ponticus]

Thanks VoG II - I was inserting a UserForm and I accidentally inserted a Class Module and I had no idea what it was - a goog search didn't help much It's amazing how you can use an application for months and not know all the options availible - never really noticed the Class Module

 

[VoG]

Ah, yes, well I've lost count of the number of times I've inserted a UserForm when I meant to insert a Module

I believe that one can do very clever things using Class Modules so I don't want to discourage you from exploring...

 

[Evagrius Ponticus]

haha, I suppose even the experts are "prone to error" Thanks VoG II

 

[RoryA]

If it helps, your userform is a sort of class!