Error Handling & Debugging (Part 1) in Microsoft Excel 365 for Windows

preview_player
Показать описание
In this video which is the first part of the series Error Handling & Debugging, we learn about Error Handling. Error Handling is a very useful & significant mechanism for any programming language. If error handling is not done properly and if an error happens then the code breaks.

Watch the video to understand how to proactively handle errors.

----
00:00 Intro
01:31 Types of Errors
02:53 Syntax Error
04:13 Runtime Error
06:40 On Error Statement
08:38 On Error GoTo (line)
10:59 On Error Resume Next
13:58 On Error GoTo 0
16:20 Check if worksheet exists using On Error Resume Next
18:10 Err Object
23:35 Erl
25:15 Resume Statement
29:04 Application Events and Resume statement
31:20 Funny Line Labels
32:15 Outro
----

Equipment/Software used for recording and editing this video

Disclaimer: The above are affiliate links. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!

Connect with me on social:

#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel
Рекомендации по теме
Комментарии
Автор

Very informative & lucidly explained.

Really loved it.

debabratasahachowdhury
Автор

Great video.

Could you make one on how to write VBA in an object oriented way, covering class factories, composition and interfaces.

Thanks

noviceprogrammer
visit shbcf.ru