G Guest Oct 28, 2005 #1 How do you set up a mcro in excel 2003 to accept keyboard input when it is run?
G Guest Oct 28, 2005 #2 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.
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.
G Guest Nov 10, 2005 #3 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?
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?
