VBA Classes

[Jameo]

Hi all,

I am attempting to use some classes to group together a number of option and check boxes on my forms.

Does anyone have a link handy with an introduction explaining their usage? I have found some examples of code in various places, but would ideally like a little bit of a narritive along with the code.

Many thanks

 

[Jameo]

Cheers Sektor thats great mate

Thanks so much for your help

 

[Sektor]

Not at all! Glad to help!

 

[Jameo]

I'm just getting an error:

User-defined type not defined

on:

Public EventTrapper As EventsTrapper

Any ideas why this would be?

I should add that I modified the code slightly for OptionButton as oppose to CommandButton, but I guess this should be fine?

 

[Sektor]

Then you must change everywhere CommandButton to OptionButton: in ThisWorkbook module and in class module.

 

[Jameo]

Hi Sektor, I believe I did that. However, because it was possible I made a mistake, I copied the code exactly as written in this thread and I am stillr eceiving the same error.

Sorry about this

 

[Jaafar Tribak]

I'm just getting an error:

User-defined type not defined

on:

Public EventTrapper As EventsTrapper

Any ideas why this would be?

I should add that I modified the code slightly for OptionButton as oppose to CommandButton, but I guess this should be fine?

That error indicates that the code can't find the Class module.
Make sure the Class module has exactly the name of EventsTrapper. You can do that via the VBE Properties window.

 

[Jameo]

Great stuff Jaafar, thanks mate

 

[Sektor]

Also, you can trap Application and chart events.
Applications events - events that are raised by Excel instance. For instance, you can handle "NewWorkbook" event which is raised when new workbook is created.