Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
https://www.wiseowl.co.uk - Almost every procedure you write in VBA has the potential to go wrong at some point! Writing error handling code allows your procedures to fail gracefully instead of dumping the user out into the run time error dialog box. This video teaches you all about the On Error statement including how to ignore errors, how to trigger a custom error handler and how to resume running your code after an error has occurred. Towards the end of the video you'll also encounter the Err object which allows you to interrogate the error that has occurred and even raise your own custom errors.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo) канала WiseOwlTutorials
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
https://www.wiseowl.co.uk - Almost every procedure you write in VBA has the potential to go wrong at some point! Writing error handling code allows your procedures to fail gracefully instead of dumping the user out into the run time error dialog box. This video teaches you all about the On Error statement including how to ignore errors, how to trigger a custom error handler and how to resume running your code after an error has occurred. Towards the end of the video you'll also encounter the Err object which allows you to interrogate the error that has occurred and even raise your own custom errors.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo) канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel VBA Introduction Part 20.1 - Event Procedures](https://i.ytimg.com/vi/0EXdPcbsTZI/default.jpg)
![How to make your Excel VBA code run 1000 times faster.](https://i.ytimg.com/vi/GCSF5tq7pZ0/default.jpg)
![A Simple Way to Implement VBA Error Handling](https://i.ytimg.com/vi/lR5e8gyA69U/default.jpg)
![Excel VBA - Error Handling](https://i.ytimg.com/vi/gn37Awyxxt4/default.jpg)
![VBA Error Handling Explained in Plain English (with examples)](https://i.ytimg.com/vi/gKIOIXriXEI/default.jpg)
![On Error GoTo, On Error Resume Next, and GoTo 0 in Excel VBA - Code Included](https://i.ytimg.com/vi/QuBQuKxg7x0/default.jpg)
![Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page](https://i.ytimg.com/vi/dShR33CdlY8/default.jpg)
![Excel VBA Introduction Part 21 - User Forms](https://i.ytimg.com/vi/CzP8nO9UVvY/default.jpg)
![Learn VBA with Excel Beginners Marathi ( मराठी )](https://i.ytimg.com/vi/93PPm-5oR3c/default.jpg)
![Excel VBA Introduction Part 24 - File Dialogs](https://i.ytimg.com/vi/6ZIFNAV1rOQ/default.jpg)
![Excel VBA Introduction Part 25 - Arrays](https://i.ytimg.com/vi/h9FTX7TgkpM/default.jpg)
![VLookup Error Handling Excel VBA](https://i.ytimg.com/vi/cl4CiVtAwOk/default.jpg)
![Excel VBA Introduction Part 35 - Class Modules](https://i.ytimg.com/vi/MjbmsVDnAL0/default.jpg)
![Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell](https://i.ytimg.com/vi/pI2px2KoapU/default.jpg)
![Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)](https://i.ytimg.com/vi/c8reU-H1PKQ/default.jpg)
![The Three Types of Errors in Excel VBA](https://i.ytimg.com/vi/gSHjyN6JPcY/default.jpg)
![Excel VBA Introduction Part 15 - Do Until and Do While Loops](https://i.ytimg.com/vi/wGauctajWPQ/default.jpg)
![Excel VBA Introduction Part 17 - For Each Loops](https://i.ytimg.com/vi/R2nlDu-2E4o/default.jpg)