ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Determining the Name of a Caller Macro (https://www.excelbanter.com/excel-programming/295412-determining-name-caller-macro.html)

SidBord

Determining the Name of a Caller Macro
 
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?

Frank Kabel

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?



No Name

Determining the Name of a Caller Macro
 
Yeah, I've done that . . . just hoping there was a
function. Thanx.
-----Original Message-----
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?


.



All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com