How can a macro accept keyboard inputwhile running?

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

Guest

How do you set up a mcro in excel 2003 to accept keyboard input when it is run?
 
You can use the InputBox command

z = InputBox("Test", "Test")

Z will return whatever value is typed into the prompt that will be displayed
upon running.
 
Is there no other way to to do this other than the input box - just seems too
"kludgy" to me. I am working on a macro which moves through input cells and
would like to do the same thing without all the pop up input boxes?
 
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

How can I save variable when 'end'? The user then reactivates the 3
Stop a macro 1
Opening a csv file stops macro 7
use find to find fill? 2
Macros 2
MS Query "Connections" 16
How do I get an Excel macro to run completely using the keyboard? 5
Lock Keyboard input 1

Back
Top