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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA macro pausing 2
pausing a macro to input cell contents 3
How do I pause a macro to select specific cells 1
Pause Macro, take action, then continue 2
Print Macro - PDF Issue 1
Pause in an Excel Macro 1
Macro to Reset data input form 5
Can you pause a macro in excel to input data and continue? 1

Back
Top