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