View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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?