| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining a call in a macro | Excel Discussion (Misc queries) | |||
| Determining if Macro Can Run | Excel Programming | |||
| application.caller | Excel Programming | |||
| Determining the immediate caller of a function | Excel Programming | |||
| DDE and application.caller help | Excel Programming | |||
Linear Mode
