Qs: How to get procedure name?

Hi,
How can i get prodecure name?

Public Sub PrvName()
MsgBox PRODECURE NAME <-
End Sub

Very thanks.

I believe you cannot. However, there's a free VB Add-Inn (MZ-Tools), which can get it for you with just one click in the IDE :)

It's simple, but not quite that simple. What you do with MZTools is to click its Options button, click Error Handler, for example, and enter something like this:

Code:

---

    On Error GoTo ErrorRoutine

        {PROCEDURE_BODY}

    Exit {PROCEDURE_TYPE}

ErrorRoutine:

    DisplayError "{PROCEDURE_NAME}"

---

then in every procedure you click MZTOOLS Add Error Handler button and it replaces {PROCEDURE_NAME} with the name of the procedure. The other variables are also filled in of course.