PAUSE EXCEL MACRO FOR INPUT OF DATA VARIABLE

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

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.

lynne b wrote:
>
> How do I pause a macro in Excel 2003 for input of a data variable and then
> restart running the remainder of the macro

--

Dave Peterson