| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get an excel macro to stop at a cell & wait for imput?
What can be used to replace the "{?}" command used in lotus macros to pause
and wait for data entry? The lotus macro worked fine in excel 97 but after switching to excel 2003 did not. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get an excel macro to stop at a cell & wait for imput?
You can use the inputbox, as in:
Sub test() Dim YourInput As String YourInput = InputBox("What is your input?") MsgBox ("Your input was " & YourInput) End Sub "oscar_az" wrote: What can be used to replace the "{?}" command used in lotus macros to pause and wait for data entry? The lotus macro worked fine in excel 97 but after switching to excel 2003 did not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) | |||
| How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
