In short... No. there are a few techniques I have seen posted but in general
they all have pretty significant drawbacks. Here is what you can do

1. Use an input box to get info from the user (good if you only want really
simple input)

2. Use a user form to get user input (good for more complex input)

3. End the macro at the point of requireing input. Catch change events
occuring in the spreadsheet to initiate the final code.
--
HTH...

Jim Thomlinson


"Fan924" wrote:

Can a macro pause for a data entry before finishing?