Pausing Macro

[Dohko]

Hi

Is there a way to pause a macro while it is running?
For example:

COL A COL B
1 2
b 4
5 5

My current macro highlights all characters in this case b.
Is there a way to make it stop when it highlights b, and make it continue running when I want? I'm using a Form for this purpose.

Thanks

[Leith Ross]

Hello Dohko,

Place a MsgBox in your macro code at the point it finishes highlighting the data.

MsgBox "Click OK to continue."

Sincerely,
Leith Ross

[Dohko]

Yes, I tried that. But I need to play with the data before I can continue running the program.
MsgBox won't let me touch the spreadsheet unless I click yes or no. or close it.

[dominicb]

Good afternoon Dohko

So why not split your code into two macros?

HTH

DominicB

[Dohko]

Actually it's 2 macros.
The actual situation is this.
I have a macro that colors cells that have errors.
I want to be able to modify them and then continue running the macro.
Like for example I fixed one cell and then just press continue or something like that

[bhofsetz]

There are several things you could do depending on the complexity of your macro code.

-When the error is found you could have the code open an input box which
would prompt for the correct information then overwrite the errenous cell
with the correction. The code would be 'paused' until a value is entered into
the input box. This would also allow you to check the value entered into the
input box before continuing.

-You could open a modeless userform which alerts the user to the errenous
cell and will allow them to interact with the spreadsheet while the userform is
open. Then when the correction is made they can click 'Continue' or
whatever button you choose on the userform.

-If your code and data being checked is relatively small you could highlight
the errenous cell and simply have the code end. Then recheck all data from
the beginning with the new correction in place and if your code or data isn't
extreemly large then the user won't see any significant difference in
execution time.

HTH