Accessing the call stack in an Excel VBA macro?
 

There is a control which lists the call stack members when you are in the
VBA programming environment. I need to access this from within a VBA macro
at run time. Does anybody have a clue how to do this?

Accessing the call stack in an Excel VBA macro?
 

According to Ken Getz in the VBA Developer's Handbook...
"VBA doesn't provide any method for retrieving this information"
--
You would have to write your own code to keep track of calls/releases.
--
Jim Cone
Portland, Oregon USA
(compare stuff, find stuff, remove stuff: http://tinyurl.com/XLCompanion)




"Mike Suman"
wrote in message
There is a control which lists the call stack members when you are in the
VBA programming environment. I need to access this from within a VBA macro
at run time. Does anybody have a clue how to do this?