Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can you get a log of the "thread" of lines used, when your macro run?

Hi,

When a macro run and by calls jump between procedures, it would be great to
get a log of the "tread" line by line. That would make it more easy to
debug, right? Is there a software or a way to achieve this?

/Regards


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Can you get a log of the "thread" of lines used, when your macro run?

You might already know about these methods, but here's some possibilities I
can think of:

You could just put a breakpoint at the area that you're interested in, run
the code, and then once it's reached your breakpoint, View|Callstack
(Ctrl+L).

Or you could put Debug.Print "functionname" at the start of each
sub/function (or write a program to insert this line in each sub/function
for you). Then after running your macro you could View|Immediate Window
(Ctrl+G) to see all of the sub/functions that were called.

-Erik

"Marie J-son" wrote in message
...
Hi,

When a macro run and by calls jump between procedures, it would be great
to get a log of the "tread" line by line. That would make it more easy to
debug, right? Is there a software or a way to achieve this?

/Regards



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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Text Thread "Return" Without Leaving the Cell ConfusedNHouston Excel Discussion (Misc queries) 1 February 25th 08 04:31 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" Dennis Excel Discussion (Misc queries) 0 July 17th 06 02:38 PM
Should I generally request "post a poll" when I post a new thread? Joe Miller Excel Discussion (Misc queries) 2 January 7th 06 04:46 PM


All times are GMT +1. The time now is 10:04 PM.

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"