Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Classes in VBA blogs

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | no comments

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

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.