Thread: How can a macro accept keyboard inputwhile running?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gil Gray Gil Gray is offline
external usenet poster
  
Posts: 1
Default How can a macro accept keyboard inputwhile 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?

"galimi" wrote:

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.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"WillyNPG" wrote:

How do you set up a mcro in excel 2003 to accept keyboard input when it is run?
Reply With QuoteReply With Quote