The Basics of Error Handling in VBA

  Рет қаралды 1,608

codekabinett.com/en

codekabinett.com/en

2 жыл бұрын

Error handling often carves out a miserable existence in the shadows of glorious functionality. Nevertheless, it is essential for a good user experience. Every VBA developer should at least know the basics of error handling in #VBA.

Пікірлер: 5
@shadow9449
@shadow9449 2 жыл бұрын
"...if you don't care if your program executes the way you intended, then why write the program in the first place?" Classic Philipp line! I loved it! :) I've been using the kind of error handling described for years now and I still learned quite a bit! Awesome video Vielen Dank!
@CeliaAlvesSolveExcel
@CeliaAlvesSolveExcel 2 жыл бұрын
Hi, Philipp. Thank you for this video. As always, a lot of very good advice and things to think about. You mentioned another video about Resume Next but it seems you might have forgotten to add the card for that video. Would you please like to add that? Thank you.
@codekabinettcomen
@codekabinettcomen 2 жыл бұрын
Hi Celia! Thank you for the feedback. I just double checked. The card with the video link is configured correctly but I think cards will not show in some web browsers and apps. The link to the On Error Resume Next video is: kzfaq.info/get/bejne/hsp4jbd7mNWcdIU.html
@johnclark851
@johnclark851 2 жыл бұрын
Good morning Philipp, quoting Goethe's Faust...impressive to see your skills go beyond coding! I almost skipped over this video because I felt this is something I have mastered... and for the most part I have. That being said, this is the ONLY video/website I have come across that takes the time to explain the actual PLACEMENT of the labels. When I first started using error-handling, I was getting that generic "no errors" message and it was Paul Baldy that explained the need for an exit-handler as well, but he didn't explain how it needed to be BEFORE the error-handler. Common sense? It is now, but to an VBA novice with no coding experience, not so much! I have a request/suggestion for a video tutorial: As you pointed out, a "Goto Label" should only be used for error-handling and I agree and I try to avoid them as much as possible. But when I am performing a loop and an error occurs, how do I skip that error, alert the user/admin with either a msgbox or a write to an error log, and resume the loop?
@codekabinettcomen
@codekabinettcomen 2 жыл бұрын
John, thank you very much for your feedback! Your suggestion is very good. I already planned to do a "part 2" of this topic, now I guess it also needs a "Part 3".
Windows API in VBA - Strings (Part 1)
30:44
codekabinett.com/en
Рет қаралды 3 М.
Query Performance Tuning - Basic, Universal Rules
32:59
codekabinett.com/en
Рет қаралды 2,9 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 18 МЛН
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 32 МЛН
VBA Error Handling Explained in Plain English (with examples)
23:13
Excel Macro Mastery
Рет қаралды 46 М.
Advanced Exception Handling in Python
12:06
NeuralNine
Рет қаралды 57 М.
Better VBA 10 - To comment or not to comment
17:54
codekabinett.com/en
Рет қаралды 1,4 М.
Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)
34:58
Windows API in VBA - Strings (Part 2) - Unicode vs. ANSI
40:59
codekabinett.com/en
Рет қаралды 2,5 М.
Using the Soundex Algorithm in Microsoft Access
25:55
codekabinett.com/en
Рет қаралды 1,9 М.
How to Zip and Unzip Files and Folders Using Microsoft Access VBA
16:16
Computer Learning Zone
Рет қаралды 1,2 М.
Table Validation Rules in Microsoft Access
29:42
codekabinett.com/en
Рет қаралды 4,9 М.
Rust and RAII Memory Management - Computerphile
24:22
Computerphile
Рет қаралды 221 М.
Худшие кожаные чехлы для iPhone
1:00
Rozetked
Рет қаралды 902 М.
iPhone 15 Pro в реальной жизни
24:07
HUDAKOV
Рет қаралды 422 М.
1$ vs 500$ ВИРТУАЛЬНАЯ РЕАЛЬНОСТЬ !
23:20
GoldenBurst
Рет қаралды 1,8 МЛН
Как удвоить напряжение? #электроника #умножитель
1:00
Hi Dev! – Электроника
Рет қаралды 932 М.
Как бесплатно замутить iphone 15 pro max
0:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 1,3 МЛН
Это - iPhone 16 и вот что надо знать...
17:20
Overtake lab
Рет қаралды 109 М.