There is a setting under toolsOptionsEdit Move Selection after enter -
select this tick box and then change the direction as appropriate.

Don't know the VBA for this but you could find out probably using a recorded
macro.


"helpwithXL" wrote in message
oups.com...
hi
just wondering if its possible to capture the pressing of enter key in
excel?.
normally if enter key is pressed in cell, next cell is selected. I want
to change (over ride) this behaviour of enter key. i want that when
user presses enter key inside the cell, the cursor should go to next
line in the same cell. right now "alt" key needs to pressed to achieve
this but is it possible to capture this event when enter key is pressed
so that i can change what it does.
any help is appreciated.

regards,
helpwithxl