| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can a macro accept keyboard inputwhile running?
How do you set up a mcro in excel 2003 to accept keyboard input when it is run?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro keyboard shortcuts | Excel Programming | |||
| keyboard shortcut for a macro | Excel Worksheet Functions | |||
| Keyboard Shortcut in Macro | Excel Discussion (Misc queries) | |||
| Macro keyboard shortcuts | Excel Programming | |||
| Can we modify the macro to accept multi-inputs? | Excel Programming | |||
Linear Mode
