Which Procedure was I call from?

[obiron]

Hi guys,

Hopefully a quick question.

I have a sub which is called from a number of different places and I want it to do something different if it is called from one specific place which I would rather not do using parameters.

How can I find out using VBA which procedure called the procedure that I am in. I only need to go back to the immediate parent but if there is generic code that can find all acestors that would also be useful.

Regards

Obiron

 

[Hermanito]

As far as I know you don't have access to the call-stack programmatically...

Why don't you want to use a parameter? You can use an optional parameter so that you can leave all existing code as-is, only adapt the one specific place where you want to be alerted...

 

[cstimart]

I would go into the editor, find all the calls to that Sub and put a breakpoint on the call...then when the code runs, you can she what area/breakpoint it was called from.