Posted to microsoft.public.excel.programming

galimi[_2_] galimi[_2_] is offline

external usenet poster

Posts: 65

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro keyboard shortcuts	Mitch	Excel Programming	6	March 4th 08 06:38 PM
keyboard shortcut for a macro	Gary[_2_]	Excel Worksheet Functions	3	October 24th 07 07:25 PM
Keyboard Shortcut in Macro	osaka78	Excel Discussion (Misc queries)	3	January 16th 06 08:47 AM
Macro keyboard shortcuts	Roger PB	Excel Programming	2	March 25th 05 02:49 PM
Can we modify the macro to accept multi-inputs?	J_J	Excel Programming	1	January 10th 05 10:22 AM

All times are GMT +1. The time now is 09:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us