G Guest Jun 10, 2006 #1 How do I pause a macro in Excel 2003 for input of a data variable and then restart running the remainder of the macro
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 Jun 10, 2006 #2 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.
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.
