Qs: How to get procedure name?

[Yoosha]

Hi,
How can i get prodecure name?

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

Very thanks.

[gavio]

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

[MartinLiss]

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:

    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.