Advanced track

Advanced lessons

Design class modules, event-driven workflows, and performant automation apps.

1. 1

   Class Modules for Maintainable Tools

   Model report rows and validators as classes instead of scattered public variables.

2. 2

   Workbook and Worksheet Events

   Trigger validation and logging when users change key cells or open the file.

3. 3

   Performance - Arrays vs Range

   Profile macros and choose array batch operations for large workbooks.

4. 4

   Application Structure and Modules

   Organize code into modUtilities, modExport, and class layers for team handoffs.

5. 5

   Testing and Release Checklist

   Verify macros on copies, document assumptions, and ship with a rollback plan.

Back to all tracks