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

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?
 
D

Dave Peterson

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.
 
M

Mike H

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

Macro to Reset data input form 5
Combine macros variable help 2
how can a macro be paused for input and then resume executio 2
Print Macro - PDF Issue 1
Macro - a way of recording the date 3
How do I pause a macro to select specific cells 1
alphnumeric if then statements? 3
Pause Macro, take action, then continue 2

Top