MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Custom VBA Class Development

Course Summary

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 Syllabus

    Class Modules
    - 1h 15m

    —Introduction 1m 2s
    —Assumptions 1m 49s
    —Motivating Classes 7m 3s
    —Working With Word.Application 10m 22s
    —Creating a Class 4m 49s
    —Creating a Class Demo 2m 35s
    —Simple Property 1m 56s
    —Simple Property Demo 1m 10s
    —Creating Methods 2m 9s
    —Creating Methods Demo 3m 19s
    —Property Procedures 5m 15s
    —Property Procedures Demo 8m 16s
    —Property Set 2m 29s
    —Property Set Demo 2m 29s
    —Property Issues 5m 6s
    —Creating Enumerated Values 1m 55s
    —Creating Enumerated Values Demo 5m 22s
    —Initialize and Terminate Events 1m 7s
    —Initialize and Terminate Events Demo 3m 27s
    —Important Observations 2m 33s
    —Summary 0m 40s
    Collection Classes
    - 31m 46s

    —Introduction 0m 35s
    —Built-in Collection Classes 1m 52s
    —Built-in Collection Classes Demo 6m 17s
    —Motivating Custom Collection Classes 1m 37s
    —Motivating Custom Collection Classes Demo 1m 25s
    —Finishing the Custom Collection Class 1m 33s
    —Finishing the Custom Collection Class Demo 5m 13s
    —Extending the Collection Class 1m 0s
    —Extending the Collection Class Demo 2m 31s
    —Missing Features 1m 55s
    —Missing Features Demo 2m 55s
    —Using a Collection Class 3m 44s
    —Summary 1m 4s
    Reference Issues and Events
    - 41m 41s
    Dynamic Data Structures
    - 59m 21s
    Custom VBA Class Development Summary
    - 4m 32s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:



Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url