lotus uses {?} for input, what does excel use (macros)
Check out VBA help on InputBox
examples.............
to pause for user entry
whatname = InputBox("Enter a Name")
to pause for range selection
Set rngCopyTo = Application.InputBox( _
prompt:="Select the Destination Cell", _
Title:="Copy Range Formulae", Type:=8).Cells(1, 1)
Gord Dibben MS Excel MVP
On Sun, 30 Dec 2007 18:17:00 -0800, jmoore
wrote:
i can't figure out how to get the macro to stop for the input. what is the
designation in the macro to wait for user input?
|