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.