BY TOPIC▼
EXCEL / VBA BLOGS▼
VBA MACROS BLOGS▼
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (17)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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
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.