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

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 crea

  • +

    Course Syllabus

    ● Class Modules
        ◦ Introduction
        ◦ Assumptions
        ◦ Motivating Classes
        ◦ Working With Word.Application
        ◦ Creating a Class
        ◦ Creating a Class Demo
        ◦ Simple Property
        ◦ Simple Property Demo
        ◦ Creating Methods
        ◦ Creating Methods Demo
        ◦ Property Procedures
        ◦ Property Procedures Demo
        ◦ Property Set
        ◦ Property Set Demo
        ◦ Property Issues
        ◦ Creating Enumerated Values
        ◦ Creating Enumerated Values Demo
        ◦ Initialize and Terminate Events
        ◦ Initialize and Terminate Events Demo
        ◦ Important Observations
        ◦ Summary
    ● Collection Classes
        ◦ Introduction
        ◦ Built-in Collection Classes
        ◦ Built-in Collection Classes Demo
        ◦ Motivating Custom Collection Classes
        ◦ Motivating Custom Collection Classes Demo
        ◦ Finishing the Custom Collection Class
        ◦ Finishing the Custom Collection Class Demo
        ◦ Extending the Collection Class
        ◦ Extending the Collection Class Demo
        ◦ Missing Features
        ◦ Missing Features Demo
        ◦ Using a Collection Class
        ◦ Summary
    ● Reference Issues and Events
        ◦ Introduction
        ◦ References as Pointers
        ◦ Successful Termination Demo
        ◦ Simple Termination
        ◦ Failed Termination Demo
        ◦ Failed Termination and Cleanup
        ◦ Cleanup Demo
        ◦ Cleanup Successful
        ◦ Cleanup Summary
        ◦ Handling Events
        ◦ Handling Events Demo
        ◦ Reviewing Event Handling
        ◦ Event Blocking Demo
        ◦ Raising Custom Events
        ◦ Custom Events Demo
        ◦ Sinking Events
        ◦ Sinking Events Demo
        ◦ Summary
    ● Dynamic Data Structures
        ◦ Introduction
        ◦ Linear Data Structures
        ◦ Introducing Stacks
        ◦ Stack Code Introduction
        ◦ Stack Operations
        ◦ Stack Code Demo
        ◦ Introducing Queues
        ◦ Queue Code Introduction
        ◦ Queue Operations
        ◦ Queue Code Demo
        ◦ Linked List Introduction
        ◦ Linked List Code Introduction
        ◦ Linked List Operations
        ◦ Linked List Code Demo
        ◦ Summary
    ● Custom VBA Class Development Summary
        ◦ Summary

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

Back to Top