Excel VBA Tutorial for Beginners (Part 10/10): Debugging and Error Handling

Welcome to the Excel Macros/VBA tutorial for beginners. In this last video we'll see what errors you may encounter while coding with VBA, what debugging tools are available in Excel VBA and how to debug your code, and how to use error handling to anticipate errors (find timeline below).

00:00 Intro
00:21 Types of errors
05:25 Debugging (Break mode, step into, toggle breakpoints)
07:39 Debugging (Locals window, Watch window)
09:58 Immediate window and Debug.Print
11:21 Error handling

This was the last video of the Excel VBA Tutorial for Beginners. We have covered the list of contents below. I hope it was helpful and you learn some here. I encourage you to keep learning though. I will upload more videos soon.

Contents:
1. Introduction
2. Modules and Procedures
3. Excel Object Model
4. The Range Object
5. Variables
6. Conditions and Loops
7. Arrays
8. Messages and Input
9. Userforms
10. Debugging and Error Handling

And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga: