Blogs from Wise Owl on Classes in VBA macros

Flappy Bird in Excel VBA Part 8 - Using Class Modules

Posted by Andrew Gould on 24 April 2014

This part of the tutorial introduces the concept of class modules and shows you how to use them to organise your code.

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012

It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink.  This blog explains how you might go about creating an event sink.

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012

If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012

Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers. It's difficult, but fun - and this multi-part blog will guide you along the way.