Blogs from Wise Owl on Classes in VBA macros

Showing blogs 1-4 (out of 4)

Flappy Bird in Excel VBA Part 8 - Using Class Modules

Posted by Andrew Gould on 24 April 2014 | no comments

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

Tags:   VBA macros | Classes

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | 1 comment

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.

Tags:   Excel | Excel Visual Basic    |    VBA macros | Classes

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012 | 4 comments

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.

Tags:   Excel | Excel Visual Basic    |    VBA macros | Classes

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012 | 5 comments

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.

Tags:   Excel | Excel Visual Basic    |    VBA macros | Classes