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

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