Interrogate subroutine name

[mbentley]

Does anyone know of a way to interrogate the name of the subroutine currently running? I just want to use if for my error handler, which messages the user as follows:

MsgBox "OBJECT_EVENT - Error #" & Err.Number & ": " & Err.Description

For each event, I overwrite "OBJECT_EVENT" with the actual name of the sub. I'd prefer to write some generic code that I don't have to edit for each subroutine.

Minor point, but I thought I'd ask.
Thanks in advance.

 

[WayneRyan]

Mike,

I've seen this request many times and I have yet to see a
solution. Any way that you choose to display the subroutine
name, you're going to have to "prime" it.

I hope some can offer something different.

Wayne

 

[mbentley]

Yah, I've asked other developers this, and that's pretty much the concensus.

 

[WayneRyan]

Mike,

You never know, there are some pretty clever people here.

Wayne