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