Error Handling In Excel VBA - Part 1
In this video I show you how handle errors in VBA so the macro can take control and close down gracefully, thus removing the onus from the user.
Watch Next
• Error Handling In Excel VBA - Part 2
About
By default, when a runtime error occurs in a macro, VBA pops up a message box and hands control over to the user to decide what to do next. In most cases the user has no choice but to End the macro which may leave things in an incomplete state. But by adding our own error handling the macro can take control and ensure it closes down gracefully, thus removing the onus from the user.
In Part 1 (this video) I show how to add Error Handling to top level (parent) subroutines while in Part 2 I will extend this to child subroutines and functions.
Excel Version
Recorded using Excel Pro Plus 2021 but also works with Microsoft 365
You cannot run VBA/Macros directly in Excel online
Excel Tips Playlist
• EXCEL TIPS