Run macro but let user update spreadsheet while it runs
Yes. But I'd like to avoid stopping and restarting the macro.
In Pascal I believe there was a "keypressed" command (boolean). Using this
command you could check to see if a key was pressed by the user while the
program was running in a loop. If so, it allowed the program to go to the
buffer and get that key. Then based on what key was pressed, the program
could branch to code that performed the action the user wanted.
To put that into practical terms for my spreadsheet, I'd like the user to
simply press the "H" key if he wants to change heading or the "S" key to
change speed.
"Ev" wrote:
How can I run an Excel macro but let the user update the spreadsheet while
the macro is running?
|