Simple play icon Course
Skills Expanded

Custom VBA Class Development

by Ken Getz

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.

What you'll learn

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.

Table of contents

Custom VBA Class Development Summary
5mins

About the author

Ken Getz is a developer, writer, and trainer, working as a senior consultant with MCW Technologies, LLC. In addition to writing hundreds of technical articles over the past twenty years, he has created hundreds of hours of video courseware on various Microsoft-focused technologies. Ken has co-authored several technical books for developers, including the best-selling ASP.NET Developer's Jumpstart, Access Developer's Handbook series, and VBA Developer's Handbook series. Ken has presented sessions... more

Ready to upskill? Get started