Can a macro be paused to allow input, then continue?

  • Thread starter Thread starter Rufushenry
  • Start date Start date
R

Rufushenry

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.
 
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
 
Back
Top