| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pause during a Macro
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pause during a Macro
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pause a macro | Excel Discussion (Misc queries) | |||
| How do I pause a macro? | Excel Discussion (Misc queries) | |||
| Pause Macro 2 | Excel Discussion (Misc queries) | |||
| Pause Excel Macro | Excel Discussion (Misc queries) | |||
| Pause macro | Excel Programming | |||
![Marie[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
