Procedure name

  • Thread starter Thread starter GeorgeMar
  • Start date Start date
G

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
 
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.
 
Back
Top