This video demonstrates VBA debugging technqiues. It covers the following topics - hope you find it useful!
Syntax Errors
Compile Errors
Using Option Explicit
Run-time Errors
Stepping through code in break mode
Setting breakpoints
The Immediate Window
Using Debug.Print
The Watch Window
The Locals Window
------------------------