Pause during a Macro
 

I am trying to create a macro in Excel that will pause
midstream so that the user is able to enter information
and then, continue forward after pressing ENTER to
complete the macro.

Can this be done in Excel? I know it can be done in Word.

Thanks for your help!

Pause during a Macro
 

You could use an InputBox. It will do exactly as you are asking
automatically. - Pikus


---
Message posted from http://www.ExcelForum.com/

Pause during a Macro
 

range("b2")=inputbox("Enter desires")

--
Don Guillett
SalesAid Software

"Marie" wrote in message
...
I am trying to create a macro in Excel that will pause
midstream so that the user is able to enter information
and then, continue forward after pressing ENTER to
complete the macro.

Can this be done in Excel? I know it can be done in Word.

Thanks for your help!

Pause during a Macro
 

Right

--
Message posted from http://www.ExcelForum.com

Pause during a Macro
 

sure


--
Don Guillett
SalesAid Software

"pikus " wrote in message
...
Right.


---
Message posted from http://www.ExcelForum.com/

Pause during a Macro
 

Thanks, Don! Just couldn't quite figure out the
terminology to use in Excel.
-----Original Message-----
range("b2")=inputbox("Enter desires")

--
Don Guillett
SalesAid Software

"Marie" wrote in
message
...
I am trying to create a macro in Excel that will pause
midstream so that the user is able to enter information
and then, continue forward after pressing ENTER to
complete the macro.

Can this be done in Excel? I know it can be done in
Word.

Thanks for your help!


.

Pause during a Macro
 

glad to help

--
Don Guillett
SalesAid Software

"Marie" wrote in message
...
Thanks, Don! Just couldn't quite figure out the
terminology to use in Excel.
-----Original Message-----
range("b2")=inputbox("Enter desires")

--
Don Guillett
SalesAid Software

"Marie" wrote in
message
...
I am trying to create a macro in Excel that will pause
midstream so that the user is able to enter information
and then, continue forward after pressing ENTER to
complete the macro.

Can this be done in Excel? I know it can be done in
Word.

Thanks for your help!


.