06 – Debugging

In this post, we will be looking at Debugging in VBA. Debugging refers to the act of removing errors from your code and is absolutely vital if you want to write effective code.

List of topics covered:

  • Break on Unhandled Errors
  • Breakpoints
  • Debug Control Bar
  • Immediate Window
  • ? and Debug.Print
  • : to concatenate commands
  • ; to concatenate strings
  • Call a Procedure
  • Code Window Pop-ups
  • Watches Window
  • VBE Editor Options
  • Compilation Explained
  • Advanced Compilation and ACCDE
  • Multi-Users Environments

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!