Tabellab
Menu
Courses Guides Pricing Log in Start free
Intermediate

Errors & Debugging

Find out what your macro is really doing, and fail gracefully when something goes wrong.

8 lessons 1.1 h Certificate

Start the course Unlock all courses

The first lesson is free — no account needed.

About this course

Find out what your macro is really doing, and fail gracefully when something goes wrong. The course covers debugging with breakpoints, stepping, Debug.Print and the Immediate, Locals and Watch windows, then VBA error handling with On Error GoTo, careful use of On Error Resume Next, cleanup patterns and raising and logging your own errors.

Lessons

  1. Three Kinds of ErrorReading10 minFree
  2. Breakpoints and SteppingReading8 min Pro
  3. The Immediate Window and Debug.PrintReading8 min Pro
  4. The Locals and Watch WindowsReading7 min Pro
  5. On Error GoTo: Catching FailuresReading8 min Pro
  6. On Error Resume Next, Used CarefullyReading7 min Pro
  7. Cleanup Patterns That Never LeakReading8 min Pro
  8. Raising and Logging Your Own ErrorsReading7 min Pro