identifying caller procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

Is there any feature in VBA for identifying a caller procedure? E.g. if Sub
C is called from Sub A and Sub B, i'd like to know in Sub C that it was
called from Sub A or Sub B.

Thanks,
Stefi
 
Hi Stefi,
Is there any feature in VBA for identifying a caller procedure? E.g. if Sub
C is called from Sub A and Sub B, i'd like to know in Sub C that it was
called from Sub A or Sub B.
Click to expand...

One way would be bt using an argument:

Sub A(sCaller as String)
Msgbox "I was called by: " & sCaller
End Sub

Sub B()
A "Sub B"
End Sub

Sub C()
A "Sub C"
End Sub

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Thanks Jan Karel, I thought there is a built-in feature, but if there isn't
one, I'll use this method.
Stefi


„Jan Karel Pieterse†ezt írta:
 
Back
Top