How do I get an excel macro to stop at a cell & wait for imput?

[Guest]

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.

 

[Guest]

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