| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to enter text inside the bars on a bar chart in Excel? | Charts and Charting in Excel | |||
| How do I press enter inside a cell? | Excel Discussion (Misc queries) | |||
| How do I enter a Hard Return inside a cell? | Excel Discussion (Misc queries) | |||
| Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
| capture last cell in column | Excel Discussion (Misc queries) | |||
Linear Mode
