Debugging: How do you enter a Stop command in your code?

**Excel_vba** · 08-22-2013, 10:37 PM

I don't see it in the debug menu. Is there are keyboard short cut?

**jindon** · 08-22-2013, 10:46 PM

Just type Stop one line above where you want to pause the execution of the code.

Is this what you mean?

**Excel_vba** · 08-22-2013, 10:58 PM

Originally Posted by jindon

Just type Stop one line above where you want to pause the execution of the code.

Is this what you mean?

That looks to be it. Thank you sir.

**cytop** · 08-22-2013, 11:05 PM

Alternatively, use

Please Login or Register  to view this content.

This can be used to conditionally pause execution based on the results of a calculation

Please Login or Register  to view this content.

If the result is False, then the code will pause.

**MrShorty** · 08-23-2013, 09:01 AM

You also have the option of setting a breakpoint http://office.microsoft.com/en-us/su...819.aspx?CTT=1

**Norie** · 08-23-2013, 09:11 AM

Use F9 to toggle breakpoints and F8 to step through the code.

Re: Debugging: How do you enter a Stop command in your code?