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
cell for an input, and then after you enter the data, hit an "enter" or some
other keystroke, and the macro will continue?
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.
