run macro on return

K

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
 
E

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.
 
Top