Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
Hi all,
When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
As for a step backwards I do not know of one. You can grab the yellow arrow
at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
Hi Jim,
Thank you Jim. What I really mean is to find the last execution step. It is silly when there is few code, but when there are many if and elseif block, I think it is valuable. Clara -- thank you so much for your help "Jim Thomlinson" wrote: As for a step backwards I do not know of one. You can grab the yellow arrow at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
Clara,
You can drag the yellow arrow to any execution line within the current sub or function. Or, you can right click on any execution line (still within the same proc) then select "Set Next Statement". -- Hope that helps. Vergel Adriano "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
Hi Clara,
If you mean the last execution step in the current procedure, CTRL+DOWN ARROW will take you to the next sub or function which should be just a few lines below the last line of the current procedure you were on before pressing CTRL+DOWN ARROW. -- Hope that helps. Vergel Adriano "clara" wrote: Hi Jim, Thank you Jim. What I really mean is to find the last execution step. It is silly when there is few code, but when there are many if and elseif block, I think it is valuable. Clara -- thank you so much for your help "Jim Thomlinson" wrote: As for a step backwards I do not know of one. You can grab the yellow arrow at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
As far as I know there is no functionality to support what you are looking
for... code execution is like a like waking up after a night of drinking... it knows where it is and it can figure out where it needs to go but how it got there and where the pants went is a complete mystery... -- HTH... Jim Thomlinson "clara" wrote: Hi Jim, Thank you Jim. What I really mean is to find the last execution step. It is silly when there is few code, but when there are many if and elseif block, I think it is valuable. Clara -- thank you so much for your help "Jim Thomlinson" wrote: As for a step backwards I do not know of one. You can grab the yellow arrow at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
Jim,
Now we just need a human version of the ViewCall Stack to indicate which bars we visited and possibly ViewWatch Window to tell how much we spent. NickHK "Jim Thomlinson" wrote in message ... As far as I know there is no functionality to support what you are looking for... code execution is like a like waking up after a night of drinking... it knows where it is and it can figure out where it needs to go but how it got there and where the pants went is a complete mystery... -- HTH... Jim Thomlinson "clara" wrote: Hi Jim, Thank you Jim. What I really mean is to find the last execution step. It is silly when there is few code, but when there are many if and elseif block, I think it is valuable. Clara -- thank you so much for your help "Jim Thomlinson" wrote: As for a step backwards I do not know of one. You can grab the yellow arrow at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "Step Back"
That's a great analogy Jim! I didn't know you guys had a sense of humor.
Mike "Jim Thomlinson" wrote: As far as I know there is no functionality to support what you are looking for... code execution is like a like waking up after a night of drinking... it knows where it is and it can figure out where it needs to go but how it got there and where the pants went is a complete mystery... -- HTH... Jim Thomlinson "clara" wrote: Hi Jim, Thank you Jim. What I really mean is to find the last execution step. It is silly when there is few code, but when there are many if and elseif block, I think it is valuable. Clara -- thank you so much for your help "Jim Thomlinson" wrote: As for a step backwards I do not know of one. You can grab the yellow arrow at the left which indicates which line is executing and drag it to wherever you need it. -- HTH... Jim Thomlinson "clara" wrote: Hi all, When debugging code, sometimes, It would be handy if there is a method to step back. Since there might be a big gap between if , elseif block. I need to trace the code. Clara -- thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? | Excel Discussion (Misc queries) | |||
shortcut key to see a macro running "step by step" | Excel Programming | |||
"Multiple-step operation generated errors" | Excel Programming |