how to capture enter key inside a cell
 

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

how to capture enter key inside a cell
 

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

how to capture enter key inside a cell
 

You can change the behaviour of the Enter key to any point in the compass
with this:

Application.MoveAfterReturnDirection = xlDown

The compass constants a xlToLeft, xlToRight, xlUp, or xlDown

"helpwithXL" wrote:

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

how to capture enter key inside a cell
 

Not sure about other version of Excel but in xl2002 you can set the option
enter cell behaviour direction. Use
Tools-Options-Edit -'Move Selection After Enter' and 'Direction - Down

--
Cheers
Nigel



"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