VB Question

thkalinke

New Member
Joined
Aug 30, 2002
Messages
4
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
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

New Member
Joined
Aug 30, 2002
Messages
4
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
 

Forum statistics

Threads
1,144,329
Messages
5,723,733
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top