Excel VBA Class Modules

Excel VBA Introduction Part 35 – Class Modules


Class Modules in VBA allow you to define your own classes of objects. This video explains why that’s a useful and shows you how to go about creating a class. You’ll learn about the two class events: initialise and terminate, you’ll see how to define properties, including how to create read-only properties and set default values. You’ll also find out how easy it is to create methods for your class and how to use your class in your regular code

Be the first to comment

Leave a Reply