What Is A Real World Use Of Creating An Event In a Custom Class?

[MatthewNYC]

Hi,

I've been coding in VBA with Excel's built-in events for the Workbook and Worksheet and their usefulness is very obvious.

However, with custom classes in VBA you can also create your own events -- and raise them -- to other objects that are listening for those events.

What's unclear to me is a solid example of when this would be useful.

For example, what is a case where I would have created a custom class that I really needed to use custom events?

If someone could provide a simple real world scenario that would provide more clarity to me.

Thanks,

Matthew

 

[Rijnsent]

Hi Matthew,

two real world events could be initialize & terminate, see this tutorial: https://excelmacromastery.com/vba-class-modules/#Class_Module_Events , actually, this class tutorial has the same two events as an example: https://analystcave.com/vba-vba-class-tutorial/
Chip Pearson also has a bit on events in class modules, but his example is not real-world: http://www.cpearson.com/Excel/Events.aspx

Hope that helps a bit (not a fan of classes myself),

Koen