run macro on return

[kizzie]

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

[Earl Kiosterud]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>