Line Numbers in VBA Code?
Posted on 2002-05-06
I have a rather large VBA subroutine I wrote. I am trying to split it up, but until then, there are a few areas that might encounter an error. I'd like to know whereabouts in the module the error occurred.
Mind you, this is distributed as an MDE, so the user cannot get to the code, even during an error. Right now, I have it put up a screen, with the module name, and Access/Jet Error number. Is there a way to tell *where* in the module it happened? (Of course, I can go back and devise where it occurred, based on ErrNo, but I'm lazy that way)....
Thanks in advance.