Subroutine introspection: Can a sub know what sub called it?

[electrikmonk]

In Excel VBA, if subroutine A calls subroutine B, is there a way for subroutine B to know that subroutine A was what called it? I mean this for run-time, so not talking about watch window. Application.caller seems to give info in calling VBA from Excel, not for info about a subroutine calling it (corrections are welcome.)

Thanks for any help you can give with this.

Rich

 

[vw412]

I will step out on a limb here and based on my years of general programming (not just VBA), the answer is "No" unless you include some kind of indication as a parameter to subroutine B which routine called it. Some programming languages have this facility but usually it is implemented similarly to what I just described except hidden behind the language definition. The only thing that subroutine B might be able to use to determine who called is the return address that is pushed onto the procedure stack. But you would have to have knowledge about how compiled VBA is structured to get any meaningful information even if you could access the procedure stack from normal VBA. Better to explicitly pass a reference to subroutine B about who called.