Free Excel VBA Course #22 - Error Handling in VBA (On Error Goto/Resume)

In this video, I will show you how to handle errors in VBA in Excel.

VBA has given us some tools and techniques you can use to handle errors and In some cases use these to your advantage.

There are statements such as On Error Goto or On Error Resume where you can specify what to do in case VBA encounters an error. You can ask the code to jump to a specific line of code or you can ask it to ignore the error and keep moving.

You can also use message boxes to identify and understand the errors better.

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
00:00 Introduction
00:38 Creating a simple VBA example with input box
02:06 Understanding runtime errors
03:52 Using On Error GoTo for error handling
06:56 Creating error handling loops with Resume
10:01 Neutralizing error statements with On Error GoTo 0
12:54 Using On Error Resume Next
14:27 Working with the Error object
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial