Pausing a Running Macro

**AccountantCost** · 11-05-2009, 10:51 AM

Macro Step 1: I have a macro that prompts the user to input requested data into a dialogue box.

Macro Step 2: The macro then takes the data and places it in specific cells.

Macro Step 3: Depending on the responses in step 1, the macro may prompt the user to input more requested data into a dialogue box.

Macro Step 4: If more data is prompted in step 3, the macro takes the additional data and places it in specific cells.

Question: Is there a way to write excel macro syntax code that interrupts the running of the macro (let's say after step 2) to alllow the user to view the cells were the macro placed the data. The macro would then ask if the user approves of the cell input. If user does not approve, the macro would interrupt itself and allow the user to make modifications to the cells. After the user makes any modifications, the user can resume the macro at the point in the macro where it was interrupted.

**rwgrietveld** · 11-05-2009, 11:20 AM

I only took care of the PAUSE. Step 3 needs to be done still, but is this what you like?

Press Macro mode and you'll see what I mean.

You are either in Change mode, or Macro Mode.

It's not subtle, but just give me some pointers ...