get function that created the error

[IkeMike]

Hi folks,

i implemented some error handling in my vba project. when an error occurs i catch it and present some msg-box to the user.

now i wanted to know whether it is possible to get the function that created the error. or the line number where the error occured would also help.

thus simple question: is it somehow possible to trace back the error to get to know where the error occured?

kind regards
tom

 

[IkeMike]

thanks for all that precious information!
learned a lot of usefull stuff today! especially the watch window will ease my vba life a lot..