Excel Macro help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have the Macro function in Excel go to a cell, wait in a cell for an input, and then after you enter the data, hit an "enter" or some other keystroke, and the macro will continue?
 
No, it doesn't do that. You can write code to display an InputBox. The
user would type something in the space provided, and the code would then put
the entry in some cell as directed. HTH Otto
Mel said:
Is there a way to have the Macro function in Excel go to a cell, wait in a
Click to expand...
cell for an input, and then after you enter the data, hit an "enter" or some
other keystroke, and the macro will continue?
 
Back
Top