Custom VBA Class Development

Learn to build classes using VBA, making it easier to encapsulate and manage entities in your applications. Add properties, methods, and events to your classes, and then consume the classes as you create code. Focus on specific class-based features, such as collection classes and custom events, and learn to create dynamic data structures using VBA classes.
Course info
Rating
(50)
Level
Intermediate
Updated
Jun 27, 2014
Duration
3h 32m
Table of contents
Class Modules
Collection Classes
Reference Issues and Events
Dynamic Data Structures
Custom VBA Class Development Summary
Description
Course info
Rating
(50)
Level
Intermediate
Updated
Jun 27, 2014
Duration
3h 32m
Description

It's possible to create VBA applications for Microsoft Office and other VBA hosts without ever delving into the concepts of creating and using classes, but by skipping this important and useful functionality, you deny yourself one of the best ways to create scalable, maintainable applications. By encapsulating entities in discrete classes, you make it easier to ensure that generalized code doesn't interact inappropriately with your data. In this course, you'll learn to create and consume VBA classes, adding your own custom properties, methods, and events. You'll learn to handle specific class-based issues, such as orphaned objects and memory leaks, creating custom events and handling those events, and wrapping the Collection object in a class to extend and protect it. You'll also learn how to create standard dynamic data structures like stacks, queues, and linked lists using VBA, and you'll be astonished at how easy it is to create these using VBA classes.

About the author
About the author

Ken Getz is a software developer and a founding partner with MCW Technologies, LLC. He has been providing instructor-led, video, and online training since 1993. He has written hundreds of technical articles, and produced many training videos for Microsoft over the years. When not being a geek, he spends his time playing the piano in local theaters.

More from the author
Introduction to Microsoft Office Open XML
Intermediate
3h 44m
Jan 22, 2014
Section Introduction Transcripts
Section Introduction Transcripts

Class Modules
Hi, this is Ken Getz with Pluralsight. In this course on Custom VBA Class Development, you'll learn how and why you can use class modules to make your VBA applications more robust and make it easier to build and maintain professional level applications using VBA in Excel, PowerPoint, Word, or any other VBA host. Now, I've worked with a lot of VBA developers over the years, and most VBA developers get along quite well without using class modules, but the fact is, there are a lot of things you can only do using your own custom classes, and certainly building your own custom classes can make it easier to build applications that are easier to maintain. In this course, we'll look at several different ways to use classes. We'll start, however, by looking at just how you can create your own custom classes.

Collection Classes
Hi, this is Ken Getz with Pluralsight. In this module of our course on Creating Custom VBA Classes, we're going to take a look at using the Collection class. It's a data structure built-in to VBA and it has its great features, but there are some features it lacks as well. As you'll see, you can create your own Collection classes that encapsulate the built-in Collection objects, making it possible to do some things you can't do with the built-in Collection class.

Reference Issues and Events
Hi, this is Ken Getz with Pluralsight, and in this module we're going to take a look at two important issues that come up when creating your own custom classes. We'll look at reference issues and how to avoid problems when creating multiple classes that refer to each other, and, we'll look at creating and consuming custom events.