Home |
Search |
Today's Posts |
#1
|
|||
|
|||
run macro on return
Hello, Is it possible to run a macro every time the return button is hit? Maybe it's possible to run a script working on the column in which the return was given? thanks in advance, Kizzie -- kizzie ------------------------------------------------------------------------ kizzie's Profile: http://www.excelforum.com/member.php...o&userid=26092 View this thread: http://www.excelforum.com/showthread...hreadid=394610 |
#2
|
|||
|
|||
Kizzie,
If you mean the Enter key after keying data into a cell, the Worksheet_Change event will fire. You can put your macro code in there, or call your macro from there. This doesn't apply to pressing Enter in other situations, like in dialog boxes, menu bar commands, etc. The Alt-Enter combination is used to put a new-line inside a cell, but it won't fire a macro. -- Earl Kiosterud www.smokeylake.com "kizzie" wrote in message ... Hello, Is it possible to run a macro every time the return button is hit? Maybe it's possible to run a script working on the column in which the return was given? thanks in advance, Kizzie -- kizzie ------------------------------------------------------------------------ kizzie's Profile: http://www.excelforum.com/member.php...o&userid=26092 View this thread: http://www.excelforum.com/showthread...hreadid=394610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |