PAUSE EXCEL MACRO FOR INPUT OF DATA VARIABLE

G

Guest

How do I pause a macro in Excel 2003 for input of a data variable and then
restart running the remainder of the macro
 
D

Dave Peterson

Maybe you can use Inputbox() to get what you want.

dim myStr as string
'your code that does something
mystr = inputbox(Prompt:="please type something")
msgbox "Hey, you typed: " & mystr
'your code that does more.
 

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

Top