Pausing a macro while waiting for an input into a cell
Francois,
Macro code does not run anyway when the user is in Edit Mode.
And the can't enter Edit Mode whilst there is code running.
To start code after input, put it in the Worksheet_Change event.
NickHK
"Francois Ashton" wrote in message
...
Hi all
Hopefully this is not a dumb question and has probably been asked before,
but I can't find the answer at the moment.
I need a macro to be paused while waiting for a user to input a value into
a
cell. So once the value is inputed in the cell and "enter" is hit the
macro
continues.
I want to try to avaiod using input boxes.
Help is appreciated.
Francois
|