Can anyone refresh my failing memory on how to get a macro to move to a
given cell, wait until data is entered and then continue to the next line of
code?
Thanks.

David

hi
this is usually done with the input box method.
dim dat as string 'for text, long for number
dat = inputbox("enter somthing")
range("A1").value = dat

code will pause for the inputbox and continue after the input.

Regards
FSt1



"David Overington" wrote:

Can anyone refresh my failing memory on how to get a macro to move to a
given cell, wait until data is entered and then continue to the next line of
code?
Thanks.

David