I would like a macro to stop at certain point to allow for input of variable
information, then continue on with the rest of the macro. Is this possible
or do I have to set up two different macros?

You could use a msgbox and then check what button the user hit.
You could use an inputbox (or application.inputbox) to get lots of different
types.
You could even develop a userform that gets as much information from the user.

But then the macro isn't really stopping. It's just waiting.

On the other hand, you could have two macros, too. The choice is yours.

Rufushenry wrote:

I would like a macro to stop at certain point to allow for input of variable
information, then continue on with the rest of the macro. Is this possible
or do I have to set up two different macros?

--

Dave Peterson

Hi,

Where are the data coming from? Is it user input? If so use an input box and
macro execution will stop until the inputbox is closed

MyVar = InputBox("Please enter variable xxx")

Mike

"Rufushenry" wrote:

I would like a macro to stop at certain point to allow for input of variable
information, then continue on with the rest of the macro. Is this possible
or do I have to set up two different macros?