Pause for data entry

  • Thread starter Thread starter David Overington
  • Start date Start date
D

David Overington

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop / Pause a Macro using Pause button 4
pausing macro while cells update 6
Can a macro pause for a data entry before finishing? 4
Need a pause in my macro before printing 6
Pause in a macro 2
Stop running macro button, like Ctrl-Break button 8
Pausing a macro during execution 1
Pause Macro for a while and run the rest of the script later 2

Back
Top