Excel 2007 : Macro pause button

**Terri_Galloway** · 02-11-2009, 12:10 PM

I want to record a macro and pause it for input. I do not have a pause button in Excel but it shows up in Word. I went to all commands in both apps and it does not exist in Excel but does in Word. I've done searches on how to pause in Excel and my results show there should be a pause button in this app. My IT dept says they cannot help me. Does anyone know if this button exists in Excel 2007 and where I might find it?

**shg** · 02-11-2009, 12:25 PM

If you need to input data to the macro, then you can use the InputBox function, the Application.InputBox method, or a userform with data input fields.

If you need to add data to a sheet, then you can show a modeless user form with the prompt and instructions.

In order of ascending complexity to implement,

1. InputBox function

2. InputBox method

3. Modeless userform with prompt

4. Modal userform with data input fields

**Andy Pope** · 02-11-2009, 12:45 PM

I think you are confusing it's purpose. It's for pausing whilst you record the macro rather than pausing whilst a macro is running.

Excel does not have a macro pause facility.
Can you post a link where you found information to the contary?