ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   inserting break in code (https://www.excelbanter.com/excel-programming/348693-inserting-break-code.html)

papa jonah

inserting break in code
 
How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


Dave Peterson

inserting break in code
 
Add the single word:
Stop

near where you want to stop the code.

(Leave the project unprotected.)

papa jonah wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


--

Dave Peterson

Dave Peterson

inserting break in code
 
Or just go to your code and hit F8 to step through it???

papa jonah wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?


--

Dave Peterson

JMB

inserting break in code
 
Position your cursor where you want the break, then click Debug/Toggle
Breakpoint, hit F9, or just left click in the gray column to the left of your
code.

"papa jonah" wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?



JMB

inserting break in code
 
Sorry - you said code that runs when you open a file. You'll need to refer
back to Dave's advice. You can still step through (F8) an event handler.

"papa jonah" wrote:

How do I insert a break into code so that I can troubleshoot code that
occurs upon opening a file?




All times are GMT +1. The time now is 02:49 PM.

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