Procedure name

[GeorgeMar]

I want to pass the name of the procedure that I am
currently processing to the a massage box title, to trap
where the error is occuring.

How can I obtain the name of the procedure without having
to hardcode the name in the msgBox's Title argument?

many thanks
george

 

[Allen Browne]

You can't. VBA does not expose the name of the procedure.

You can download a utility from www.mztools.com. One of the useful things it
does is to add error-handling to any routine, and you can configure it to
add the name of the procedure to the line that calls the MsgBox. Great
little utility.