How to slow down a macro after pressing the escape key?

[Waimea]

I have a macro that I speed up using the ESCAPE KEY.

When the macro hits a specific value, I would like to slow down the macro again.

Is this possible?

And could someone explain what happens when I press the ESCAPE KEY once when running a macro?

 

[6StringJazzer]

How do you speed up the macro by using the ESC key? Please show your code. (I suggest code tags when you show code)

 

[Waimea]

Hi 6StringJazzer,

thank you for your reply.

It seems like if application.wait skips the waiting time when I press the ESCAPE key. Not sure why?

I have tried adding if statements with additional application.wait but the pressing of the ESCAPE key seems to ignore all additional wait commands.

 

[GlennJ]

Not sure why the ESCAPE KEY is speeding up your macro, it usually stops a macro.
You can go into your code in VISUAL BASICS and press the F8 KEY. This will step through your macro one line at a time. I like to split my screen sometimes, so I can see the code and the worksheet at the same time.
Not sure if this is what you're looking for, but I hope it helps.