Pause Macro to allow for editing

[Yesuslave]

Hi all,

Is there a way to pause a macro at a certain point to allow for editing, and then allow the user to resume the macro where it left off?

I'm automating a data-entry process that will return an error message if some of the data is incorrect. What I would like to do is have the program pause, allow the user to change the data on the spreadsheet in front of them, and then resume the macro.


Any ideas?

[pkirk25]

Instead of using msgbox, pop up a modal form with field to enter the correct data. Code execution is paused until the form is closed.

[Yesuslave]

The problem with that solution is that what I really need the user to be able to do is edit the worksheet directly, as the user will not know exactly which field is incorrect (and there is no way of knowing which field is incorrect, so the user will have to do a little trial and error).

So, is there a way to allow the user to edit the workbook while the macro is paused? And then allow the user to resume the macro again?