class modules

[dpaton05]

Can someone help me understand class modules please?

 

[Sulprobil]

An intro:

Classes In VBA

www.cpearson.com

 

[dpaton05]

I am struggling to understand class modules. I am not very good at reading documents and making a summary in your mind of what it was about. I understand that you can write code and store it in modules, but could someone give me a short summary about class modules please?

• The difference between them and normal modules
• what they are for
• the code you store in them
• why and when they are used

Thanks

 

[Michael M]

Dave
Have a read here....a step by step set of descriptions AND examples and how / when to use them

VBA Class Modules - The Ultimate Guide - Excel Macro Mastery

A VBA Class module is used to create your own custom objects in VBA. It is the VBA equivalent of the classes you find in languages such as C# and Java.

excelmacromastery.com

 

[MARK858]

I am not very good at reading documents and making a summary in your mind of what it was about.

Perhaps you will find a video easier to grasp

 

[Mentor82]

Hi,
I’d recommend you to watch videos on YouTube of a great guy named WiseOwl. He’s made a lot of video tutorials how to develop in VBA from the very beginning to advanced stuff including classes.

regards,
Sebastian

 

[MARK858]

@Mentor82 WiseOwl isn't a guy, it is a training company which very kindly made a load of Excel video's.