look at InputBox in VBA help

--

HTH

RP

"BeardT" wrote in message
...
I'd like to write a macro where it prompts me to enter a value for a cell
half way through without stopping. For example, I might like to include a
date once a set of data has been manipulated, after entering this, I'd
like
the macro to continue running. Is there a way Excel can do this?