Trapping error line number

[Paul Roberts]

If an error occurs, is there any way to return the module
and line that caused the error??


Many thanks in anticipation

Paul

 

[jmonty]

I am not sure what you are exactly trying to do, but I do
suspect that you are error trapping.
Comment out the lines (with an apostrophe ')of code that
say:
On Error....
When you run the application and hit the error, a more
descriptive msgbox will pop up and the line of code with
the error will be shown to you.
Hope this helps.