Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Accessing the call stack in an Excel VBA macro?
109 views
Skip to first unread message
Mike Suman
Jun 3, 2010, 2:17:48 PM6/3/10
to
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?
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?
Jim Cone
Jun 3, 2010, 7:35:54 PM6/3/10
to
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" <mcs...@eptsystems.com>
wrote in message
0 new messages