Re: Basic question - modules and class modules - what's the difference?

Tech-Archive recommends: Fix windows errors by optimizing your registry

> I just successfully implemented Jon Peltier's highlighting lines on a
chart
> modified and improved by Andy Pope. I notice that their instructions
> included the insertion of a 'class module'. I've never used one before and
> have no idea what it is really. Can someone let me know if it is something
I
> should learn about? ie does it yield significanimprovements in your
> programming to use class modules?

Class modules are used to create custom objects. Excel provides all the
objects most people need, so rarely will you need to create you own class
modules. Whatever you're doing with that chart must require custom
events/properties that have been encapsulated in the inserted class module.
The modules behind worksheets and user forms (and charts, etc) are built-in
class modules that give you access to the events/properties of those
objects.


.

Quantcast