ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Step by Step (https://www.excelbanter.com/excel-discussion-misc-queries/131013-step-step.html)

Tatebana

Step by Step
 
I thought that when I choose "Step by Step" (instead of "Run"), the Macro
would be executed step-by-step (and stop with an error when there is one)

However, when I choose "Step by Step" it brings up the Macro, allright and
highlights the title, but then what?

What do I have to press to advance to the first line of execution and then
go one by one?





Mike

Step by Step
 
F8

"Tatebana" wrote:

I thought that when I choose "Step by Step" (instead of "Run"), the Macro
would be executed step-by-step (and stop with an error when there is one)

However, when I choose "Step by Step" it brings up the Macro, allright and
highlights the title, but then what?

What do I have to press to advance to the first line of execution and then
go one by one?





Tatebana

Step by Step
 
Thank you so much. I wonder why I could not find this on a help function.

"Mike" wrote:

F8

"Tatebana" wrote:

I thought that when I choose "Step by Step" (instead of "Run"), the Macro
would be executed step-by-step (and stop with an error when there is one)

However, when I choose "Step by Step" it brings up the Macro, allright and
highlights the title, but then what?

What do I have to press to advance to the first line of execution and then
go one by one?





Dave Peterson

Step by Step
 
If you click on that Debug item and look at "Step Into", you'll see that F8 is
shown as the shortcut key.

Tatebana wrote:

Thank you so much. I wonder why I could not find this on a help function.

"Mike" wrote:

F8

"Tatebana" wrote:

I thought that when I choose "Step by Step" (instead of "Run"), the Macro
would be executed step-by-step (and stop with an error when there is one)

However, when I choose "Step by Step" it brings up the Macro, allright and
highlights the title, but then what?

What do I have to press to advance to the first line of execution and then
go one by one?





--

Dave Peterson


All times are GMT +1. The time now is 07:40 AM.

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