HELP-HOW to Pause macro until user Keystoke

[ectoid]

I cannot figure out how to write a macro such that it will pause during its operation and then wait indefinately for a user to physically press a key before continuing.
Any suggestions?
Thank you so much...

 

[Smitty]

Welcome to the Board!

You can stall code by adding a Message Box (i.E. MsgBox "Do you want to continue?")

As for the button press, you can use the SendKeys method to incorporate a keystroke into your code. You can trigger it dependent on the users MsgBox response. See the VBA helpfile for decent descriptions of both.

Hope that helps,

Smitty

 

[parry]

Hi, the simplest way requires no coding at all. When a macro is running you can press the ESC key and the macro will stop. When the User clicks the Continue button the macro will continue from where it stopped. If the End button is clicked the macro will finish at that point.

 

[ectoid]

Sweet...thank you muchly...I was converging on the messagebox, but never found the MsgBox name to look up. I'm new! HA...Thanks a lot...