http://msdn.microsoft.com/library/de...uggingcode.asp

Make sure the TOC is visible on the left, look at the sub topics.

--
Regards,
Tom Ogilvy

"Ken Loomis" wrote in message
...
Tom,

Yes, I am trying to debug my VBA. I have to send my workbooks to someone
that knows little about this stuff. And, then I am trying to get info back
to help me debug this. When you mentioned the "stack" that seemed very
appropriate. As a side note, I used to program in FORTH, which was TOTALLY
stack based. Anyone rememebr FORTH??????

Where can I look to learn more about :"call stack functionality in the
VBE"?

TIA,
Ken


"Tom Ogilvy" wrote in message
...
If you are doing this for debugging purposes, you might use the call
stack
functionality in the VBE.

--
Regards,
Tom Ogilvy

"Ken Loomis" wrote in message
...
Thanks, Tom.

I hard coded the name of the sub into all the subs so that I can call a
routine that will adds the name of the sub to a extra sheet in the
workbook
to track the progress.

I have posted that in another question because it works in my Excel
2003,
but bombs in Excel 2000.

Ken


"Tom Ogilvy" wrote in message
...
You can code the name of the sub with in it. Excel isn't
multitasking.
So
you can design the sub to know about itself.

-
Regards,
Tom Ogilvy

"Ken Loomis" wrote in message
...
Is there a way to access the name of a current sub via VBA while a
macro
is
running?

TIA,
Ken