| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force <enter to behave like <alt + <enter within a cell
I want the cursor to go to the next line within a cell when the user presses
the <enter key. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force <enter to behave like <alt + <enter within a cell
Alt+Enter does what you want. enter is not supported for this this and
macros essentially don't run while editing a cell. -- Regards, Tom Ogilvy "luckyinky" wrote in message ... I want the cursor to go to the next line within a cell when the user presses the <enter key. Does anyone know how to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force <enter to behave like <alt + <enter within a c
Tom,
Thanks for the reply. I realize that <alt + <enter does what I want it to but I need to "overload" the <enter key to act like <alt + <enter. Is there no way to do this? i.e. via a Macro or some other VBA code "Tom Ogilvy" wrote: Alt+Enter does what you want. enter is not supported for this this and macros essentially don't run while editing a cell. -- Regards, Tom Ogilvy "luckyinky" wrote in message ... I want the cursor to go to the next line within a cell when the user presses the <enter key. Does anyone know how to do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to force <enter to behave like <alt + <enter within a c
Perhaps you could do something like this:
Public Sub SetKey() Application.OnKey "~", "rTurn" End Sub Public Sub UnSetKey() Application.OnKey "~" End Sub Sub rTurn() ActiveCell.Value = ActiveCell.Value & Chr(10) SendKeys "{F2}{End}{Right}" End Sub -- Regards, Tom Ogilvy "luckyinky" wrote in message ... Tom, Thanks for the reply. I realize that <alt + <enter does what I want it to but I need to "overload" the <enter key to act like <alt + <enter. Is there no way to do this? i.e. via a Macro or some other VBA code "Tom Ogilvy" wrote: Alt+Enter does what you want. enter is not supported for this this and macros essentially don't run while editing a cell. -- Regards, Tom Ogilvy "luckyinky" wrote in message ... I want the cursor to go to the next line within a cell when the user presses the <enter key. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i force users to first enter data in one cell before anythi | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Force user to enter data in cell before moving to next cell | New Users to Excel | |||
| how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
Linear Mode
