28 Jan 09 VBA Error Handling with line numbers
Sometimes it is easier to find an error if we know the code line where the error occurred. I have a method to show this in an error message.
This is a light version of my error handler and focuses only to the line number of the error.
There is a variable called “erl” which contains the line number of the error, so we can use it in the error message:
MsgBox Err.Number & " - " & Erl & " - " Err.Description
But this will show 0 instead of the line number if we didn’t put numbers at the beginning of the rows.
Dick Kusleika wrote about the MZ Tools, and MZTools is a great tool for this too.
There is an “add line number” icon on the toolbar which made the line numbering in my stead.
Add Line Number Icon
Voila, it is done, and we can use it.
04 Jan 09 This is the beginning of a beautiful blog…
A new Excel, Access, VBA blog arrived onto this world.
The happy father is Zoltan Till, a Hungarian developer from Budapest.
Yes, that’s me!
I’ve created a wide variety of business applications since 2000. I’m a Hungarian programmer, trainer, presenter in conferences, and consultant from Budapest. My favorite topic is Excel but I’ll also write of some other subjects because I have been working with SAP, Oracle, MS SQL, Lotus Notes / Domino, and BO (Business Objects) too.
The adventure begins soon.
Subscribe!
