VBA - Including Line Numbers In Your Error Handler
ฝัง
- เผยแพร่เมื่อ 1 พ.ค. 2024
- 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) - วิทยาศาสตร์และเทคโนโลยี
Thanks so much, it is helpful.
You're very welcome.
Amazing!! Subbed!
Glad you liked it.
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
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.
Thanks u. Whats te program or extensiom to add line numbers?
Mz-Tools => www.mztools.com/
@@DanielPineault Thanks you!
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.