entering cell values while a macro is running

[oldbrewer]

Is it possible to have th emacro pause in some way and hand control to the keyboard and then resume running after say 10 seconds ?

 

[oldbrewer]

many many thanks !

 

[oldbrewer]

not quite there- can I be offered a 2 second window to populate A1, and if I do nothing the macro should resume after 2 seconds ?

 

[Arithos]

I do now know of a way, you can stop it in a specific spot, else you will have to cancel the macro all together, and start it again.
You could change it into parts, and make it exit sub, then change A1, and use an if statement to goto another part of the code.. Then again, I dont know what your code looks like =(

 

[FormR]

not quite there- can I be offered a 2 second window to populate A1, and if I do nothing the macro should resume after 2 seconds ?

Try:

Dim d As Date
d = DateAdd("s", 2, Now)
Do Until d < Now
    DoEvents
Loop

 

[Arithos]

Try:

Dim d As Date
d = DateAdd("s", 2, Now)
Do Until d < Now
    DoEvents
Loop

That works on my end.

I will put that in my "black box" of cool little macro helpers. Tho, you would need to know where in the code you would like to change something.
Could you implement a

If "somebutton" is pushed

then goto "pause-DoEvents-part"

?

 

[oldbrewer]

thanks again FormR - come to London and I will buy you a beer !!!!

 

[oldbrewer]

You are UK where - I buy beer in Newcastle also....