Can someone please tell me if it is possible to write an Excel macro that will pause at a certain place and wait until the user does a keystroke at which time the macro will resume execution? I do not want to use inputbox or msgbox. Thanks.
Printable View
Can someone please tell me if it is possible to write an Excel macro that will pause at a certain place and wait until the user does a keystroke at which time the macro will resume execution? I do not want to use inputbox or msgbox. Thanks.
Excel VBA question moved to Office Development.
Um, yes and no. No in the sense it isn't an option you can select in the dropdown list in the macro builder. And yes in the sense that you can program it in a module within Access and then set a Macro to run that section of code.
But, you will need to use Windows API to watch for keystrokes and when it receives one to continue. Don't think their is anything prebuilt in Office VBA for this.
Thanks, but I'm not using Access. I want to write a macro that loops through some code and displays some data; but I want the user to be able to suspend the looping with a keystroke or a mouse click, and then resume looping with another keystroke or mouse click.
How do you mark an item as 'resolved'?
When you are viewing this thread...under "Thread Tools"Quote:
Originally Posted by doasidont