Calling macro "B" from macro "A"

[Titian]

Is there any way to recognise in macro "B" that it has been called by macro "A" - so that the functionality of macro "B" may be altered?

Macro "B" is also run as a stand-alone program from time to time.

Thanks for your interest.

 

[James006]

Hi,

What about using Application.Caller

Excel VBA Macro: Determine Which Button, Control or Command Button Was Clicked


HTH

 

[Titian]

Thanks James006, however I can't see how this helps.

In macro "A" is a statement "Call macroB" - I would just like macro "B" to realise that it has been called by macro "A".

Hope that clarifies somewhat.

 

[James006]

Without your constraints and your underlying reasons, it is not easy to guess your intent ...

You could have a flag (True, False) set by a condition and stored in a public boolean variable ...

HTH

 

[Titian]

That sounds interesting James006, please tell me how exactly I would create the public boolean variable and then how macro "B" would read that variable.

Thank you.

 

[James006]

At the very top of a standard module, you can declare your variable:

Public bcall As Boolean

Then, in your different macros, depending on your conditions you can set the value

bcall = True or bcall = False ...

HTH

 

[Titian]

Thanks James for your help.

I have something that appears to be working OK in testing, lets see what happens with the real stuff later!

Appreciate your help.