wait_key and excel
Posted by william page on July 17, 2000 4:53 PM
How do I write a macro that will run in the background of my excel template and only produce action when the user performs a specific action. I would like my macro to respond to the user pressing the <enter> key or the <esc> key. I do not want to use a macro shortcut key because the macro is very complex. ie multiple inputs recordsets etc. I would like to use a wait key function and have it read the input when <enter> is pressed
Posted by Ryan on July 17, 0100 7:23 PM
You'll have to set up an application level event procedure to call your code when a particular key is pressed. Hope this points you in the right direction
Ryan
Posted by Ivan Moala on July 17, 0100 9:18 PM
As well as Ryans suggestion
Also lookup;
Do Events
Ivan
