Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.programming
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call Stack Available ? Neal Zimm Excel Programming 5 March 11th 10 05:51 PM
access the call stack? mark Excel Programming 1 February 28th 08 08:23 AM
VBA access to call stack Matthew Pfluger Excel Programming 3 September 26th 07 05:15 PM
call stack question William Barnes Excel Programming 3 December 21st 04 12:27 AM
call stack question Dave Ring Excel Programming 2 October 4th 03 02:01 AM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"