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