Excel VBA Introduction Part 35 - Class Modules

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-goul...

By Andrew Gould

https://www.wiseowl.co.uk - 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.

You can view a written version of our class modules tutorial at https://www.wiseowl.co.uk/blog/s237/c...

If you're interested in learning how to create the Flappy Bird game in Excel you can follow a written tutorial here https://www.wiseowl.co.uk/blog/s398/f...

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

• #education
• #microsoft_excel_software
• #visual_basic_for_applications
• #class
• #class_module
• #property
• #method
• #read_only
• #enum
• #wise_owl