Get function or sub name

Topic

New Reply

Is there a way to obtain the name of the active function or sub in VBA?. This can be very useful in error handling.
CurrentObjectName gives the name of the module, not the name of the active function or sub!
Thanks in advance.

Reply | Quote

Replies

I haven’t found any way but setting a constant in each routine to hold the name of the particular sub or function and then including a reference to that constant in your error handler.

Reply | Quote

That was also my solution, but I did not like it. I hoped for a more elegant way to get the function name. Pity….
Thanks for the effort.

Bart Stam
Software developer
PGGM Zeist

Reply | Quote