Blogs from Wise Owl on Classes in VBA macros
Showing blogs 1-4 (out of 4)
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.
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.
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.
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.
MS OFFICE BLOGS
VBA MACROS BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR