Class Modules in VBA - Can someone explain how I can use it.

[MThrossell]

I am 66 years old and have been using VBA since Excel V5, but I have never understand why I need to use Class Modules in my Macros. Can anyone give me an example of its use. Many Thanks.

[abousetta]

Hello and welcome to the forum,

Here's an explanation from Chip Pearson (http://www.cpearson.com/excel/classes.aspx).

Hope this helps.

abousetta

EDIT: here's another good intro http://www.thelandbeyondspreadsheets...-in-excel-vba/

[MThrossell]

Excellent Help. Thank you