Pause during a Macro

[Marie]

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!

 

[pikus]

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

 

[Don Guillett]

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

 

[pikus]

Right

 

[Don Guillett]

sure

 

[Marie]

Thanks, Don! Just couldn't quite figure out the
terminology to use in Excel.

 

[Don Guillett]

glad to help