Tabellab
Advanced

Class Modules & Structure

Build your own objects, then use them to turn a thousand-line macro into something you can still read next year.

8 lessons 1.1 h Certificate

The first lesson is free — no account needed.

About this course

Build your own objects and use them to turn a thousand-line macro into code you can still read next year. You learn why VBA class modules help, create your first class, write Property Get, Let and Set and methods, use Class_Initialize and Class_Terminate, manage collections of objects and work through an invoice example.

Lessons

  1. Why Classes at AllReading12 minFree
  2. Creating Your First ClassReading7 min Pro
  3. Properties: Get, Let and SetReading8 min Pro
  4. Methods: Giving the Object Something to DoReading7 min Pro
  5. Class_Initialize and Class_TerminateReading7 min Pro
  6. Collections of ObjectsReading8 min Pro
  7. A Worked Example: Invoice and LinesReading8 min Pro
  8. Splitting a Big Macro Into ModulesReading8 min Pro