MyFunction.Name / MyFunction.Caller

A

Alexander

Is there a possibility in VBA to get the Name of the Function were my code
is running and the Name of the Function who called my function

Example:
'-------------------------------------------------
Dim MyFunctionName
Dim MyFunctionCallerName

Function Step1 ()
Step2 ()
EndFunction

Function Step2 ()
MyFunctionName = GetFunctionInfo.Name
MyFunctionCallerName = GetFunctionInfo.Caller
EndFunction
'-----------------------------------------------

As a Result I would like to have:
MyFunctionName = "Step2"
MyFunctionCallerName = "Step1"

This works in JavaScript.
Does there exist something similar in VBA?

Thanks
Alexander
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop help 6
Novice's Question re Chart Programming 3
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Prompt For Replace in Selection And More... 0
2 User Forms Comunicating? 2
ExecuteExcel4Macro Problem 2
VBA for Dependents shortcut menu 0
Macro to copy adjacent columns for a specified condition 1

Top