VBA - Including Line Numbers In Your Error Handler

  Рет қаралды 546

D Pineault - Tech, Programming and more

D Pineault - Tech, Programming and more

3 ай бұрын

Discussing VBA Error Handling and specifically how you can add the Line Number that triggered the error to it so you can easily identify exactly where the issue occurred thus making your VBA error handler truly useful to you as a developer and saving you debugging time and frustrations.
My Article On Error Handling:
• www.devhut.net/ms-access-vba-...
Useful Links:
• learn.microsoft.com/en-us/off...
• learn.microsoft.com/en-us/dot...
Add-Ins That Include Line Numbering Capabilities:
• Mz-Tools, www.mztools.com/
• VBETwister, www.vbetwister.com/
• VBA Code Generator, www.codevba.com/
My Links:
🏭 www.cardaconsultants.com/ (business)
📢 www.devhut.net/ (blog)

Пікірлер: 10
@hassanrozh6579
@hassanrozh6579 3 ай бұрын
Thanks so much, it is helpful.
@DanielPineault
@DanielPineault 3 ай бұрын
You're very welcome.
@djunabug
@djunabug 2 ай бұрын
Amazing!! Subbed!
@DanielPineault
@DanielPineault 2 ай бұрын
Glad you liked it.
@yasserelbighily6983
@yasserelbighily6983 3 ай бұрын
Many thanks for the good explanation, is that possible to make a video about doing a procedure to add the line number to our code
@DanielPineault
@DanielPineault 3 ай бұрын
It is possible to write your own code to do this using the extensibility library, but truthfully you're better using one of many Add-Ins (some of which I've included in the videos description). Also, you might simply be able to copy such code from existing open-source add-ins. That said, let me see what I can do.
@giordanocarbajalblas104
@giordanocarbajalblas104 3 ай бұрын
Thanks u. Whats te program or extensiom to add line numbers?
@DanielPineault
@DanielPineault 3 ай бұрын
Mz-Tools => www.mztools.com/
@giordanocarbajalblas104
@giordanocarbajalblas104 3 ай бұрын
@@DanielPineault Thanks you!
@DanielPineault
@DanielPineault 3 ай бұрын
I believe the VBETwister add-in also has such functionality => www.vbetwister.com/ as does VBA Code Generator => www.codevba.com/ and there are others. I've also added this information to the video description.
How To Open Internet Explorer
15:13
D Pineault - Tech, Programming and more
Рет қаралды 323
Microsoft Access - AutoResize Combo box and List box Columns
23:35
D Pineault - Tech, Programming and more
Рет қаралды 437
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
Smart Sigma Kid #funny #sigma #comedy
00:40
CRAZY GREAPA
Рет қаралды 23 МЛН
A teacher captured the cutest moment at the nursery #shorts
00:33
Fabiosa Stories
Рет қаралды 51 МЛН
Master VBA Debugging in 20 Minutes
22:08
Excel Macro Mastery
Рет қаралды 35 М.
Microsoft Access - Modern Web Browser Control - Not Rendering - Blank - Bug
18:43
D Pineault - Tech, Programming and more
Рет қаралды 353
Petition To NOT Remove VBScript
13:59
D Pineault - Tech, Programming and more
Рет қаралды 371
How to create a student terminal report system in MS Access.
18:14
Create Beautiful PowerPoint Slides with ChatGPT + VBA: Quick Tip!
6:21
Claudio Sennhauser
Рет қаралды 283 М.
Microsoft Excel - Quick Tip - Parsing Data Without Formulas!
5:30
D Pineault - Tech, Programming and more
Рет қаралды 277
Microsoft Access - Google REST API - Send Email via Gmail
41:30
D Pineault - Tech, Programming and more
Рет қаралды 870
Microsoft Access - Modernizing The Interface
30:55
D Pineault - Tech, Programming and more
Рет қаралды 2,4 М.
VBA Error Handling Explained in Plain English (with examples)
23:13
Excel Macro Mastery
Рет қаралды 46 М.
How to automate Excel with reusable Office Scripts | Excel Off The Grid
13:54
Новые iPhone 16 и 16 Pro Max
0:42
Romancev768
Рет қаралды 2,3 МЛН
iPhone 16 с инновационным аккумулятором
0:45
ÉЖИ АКСЁНОВ
Рет қаралды 10 МЛН