ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to "Step Back" (https://www.excelbanter.com/excel-programming/387301-how-step-back.html)

clara

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

Jim Thomlinson

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


clara

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


Vergel Adriano

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


Vergel Adriano

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


Jim Thomlinson

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


NickHK

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




Mike K

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



All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com