PAUSE EXCEL MACRO FOR INPUT OF DATA VARIABLE

L

lynne b

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