Pause for User Input during Macro (2000)

Topic

New Reply

Is there a way when recording a macro to make it pause for user input (without having to go to VBA to create it)? This is something you used to be able to do (I think I remember it in Excel). But, now it seems the only way to do this is to create two macros and invoke one after the user input or go to VBA to create the pause. I want to have the macro continue running after the user inputs the information and then presses Enter.

Reply | Quote

Replies

I do not know of any way to have a macro pause and allow the user to enter data into a spreadsheet. If you have to do something like this, then you have to:

1- Use the InputBox method to prompt the user for the data and then use VBA code to put it into the sheet.

2- Use a UserForm to allow the user to imput the data.

3- Exit from the macro to allow the user to enter data and then use a second macro after the data is entered. The second macro can be triggered automatically by the Workbook Change Event, or by an OnTime event.

However, all of those are going to require writing code, not just recording it.

There did use to be a way to stop recording and then resume recording in the same macro. However, this did not pause the macro during run time to allow the user to enter data, it just paused at record time. That capability was removed. You now have to record two macros and then combine them in the VBE Editor.

Reply | Quote

Thanks Legare. I suspected as much.

Reply | Quote