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".
Better VBA 10 - To comment or not to comment
17:54
codekabinett.com/en
Рет қаралды 1,4 М.
Better VBA 11 - How to use On Error Resume Next?
16:00
codekabinett.com/en
Рет қаралды 4,9 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 18 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 31 МЛН
Smart Sigma Kid #funny #sigma #comedy
00:26
CRAZY GREAPA
Рет қаралды 5 МЛН
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
МЯТНАЯ ФАНТА
Рет қаралды 9 МЛН
Query Performance Tuning - Basic, Universal Rules
32:59
codekabinett.com/en
Рет қаралды 2,9 М.
VBA Error Handling Explained in Plain English (with examples)
23:13
Excel Macro Mastery
Рет қаралды 46 М.
How to Zip and Unzip Files and Folders Using Microsoft Access VBA
16:16
Computer Learning Zone
Рет қаралды 1,2 М.
Windows API in VBA - First Steps
17:47
codekabinett.com/en
Рет қаралды 8 М.
How to Handle VBA Errors in MS Access
13:01
Sean MacKenzie Data Engineering
Рет қаралды 4,6 М.
Advanced Exception Handling in Python
12:06
NeuralNine
Рет қаралды 57 М.
How to use Early and Late Binding the right way!
10:11
Excel Macro Mastery
Рет қаралды 10 М.
Windows API in VBA - Strings (Part 2) - Unicode vs. ANSI
40:59
codekabinett.com/en
Рет қаралды 2,5 М.
Error Handling in NodeJS (Complete Guide) | Node Tutorial
17:54
Nikita Dev
Рет қаралды 40 М.
Что делать если в телефон попала вода?
0:17
Лена Тропоцел
Рет қаралды 1,4 МЛН
Сколько реально стоит ПК Величайшего?
0:37
АЙФОН 20 С ФУНКЦИЕЙ ВИДЕНИЯ ОГНЯ
0:59
КиноХост
Рет қаралды 1,1 МЛН
$1 vs $100,000 Slow Motion Camera!
0:44
Hafu Go
Рет қаралды 26 МЛН