VB Question

[thkalinke]

Learned VB from using Excel v4 for Mac. Got used to using the PAUSE command to stop and then restart a macro from place it stopped. Now, am using Office 98. My old macros don't work the same! PAUSE still stops processing, but can't restart except from beginning. Specifically, I have a pause in the middle of an IF...END.IF, and would like to know what, if anything, I can replace my PAUSE with. Warning: I know just enough macro language to be dangerous...

Many Thanks! Tom
This message was edited by on 2002-08-31 12:24

 

[Mudface]

Not sure if this is what you want, but you can set a breakpoint at a line (or lines) of code by placing the cursor in the line and pressing F9 (or clicking just to the left of the code). This will allow you to check your variable's etc in the locals window. Press F5 in the VBE editor to resume.

 

[thkalinke]

I'll try it...that's exactly what I need, a way for processing to stop if a condition is met, change a number in the worksheet, then resume processing. Thank you! Tom