Hi,
I have a generic_error_hadler which I call on error and I setup quite a fancy msgbox with lots of details but one of the detail that I have to pass is the calling procedure name at run time i.e.
I would like to call this Generic_Handler without having to setup or type the "Validation_Routine"
How can I get the calling procedure name ?
I have tried things like application.caller or
Application.VBE.... etc ut tono avail.
Thanks in Advance.
I have a generic_error_hadler which I call on error and I setup quite a fancy msgbox with lots of details but one of the detail that I have to pass is the calling procedure name at run time i.e.
Code:
Sub Validation_Routine()
On Error GoTo Error_Handler
valid = False
If Range("first_name").Value = "" Then
MsgBox "Please enter your name"
Exit Sub
End If
valid = True
Exit Sub
Error_Handler:
Application.ScreenUpdating = True
Call Generic_Handler(Err.Number, Err.Description, "Validation_Routine")
End Sub
I would like to call this Generic_Handler without having to setup or type the "Validation_Routine"
How can I get the calling procedure name ?
I have tried things like application.caller or
Application.VBE.... etc ut tono avail.
Thanks in Advance.