trap the line of error ?

[tolisss]

how can i trap in which (line & column) of module-class-form-.... has the line occured

e.g msgbox "Error on " & err.mod & err.desrc & what?

thnks

[TH1]

The only way that I know is to use line numbers in your project which if it is a big project could be a real pain. I use Numega Failsafe personally which will do all this for you but it's expensive. If you have line numbers in your project then you can use VBA.Erl to get the line the error occured on.