Thread: Determining the Name of a Caller Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Determining the Name of a Caller Macro
Hi
AFAIK there's no such VBA function. You have to implement this on you
own. e.g. add a parameter in your function/procedure call to indicate
the calling procedure.

--
Regards
Frank Kabel
Frankfurt, Germany


SidBord wrote:
Similar to my last question, I would find it very handy to
be able to determine the name of the macro that called the
currently executing macro. Is there a VBA function or
statement that will do this for me?

Reply With QuoteReply With Quote