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?

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" <luckyinky@discussions.microsoft.com> wrote in message
news:72D05C6E-87F5-4EB7-A30F-88BE74C0E038@microsoft.com...
> 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?

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" <luckyinky@discussions.microsoft.com> wrote in message
> news:72D05C6E-87F5-4EB7-A30F-88BE74C0E038@microsoft.com...
> > 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?
>
>
>

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" <luckyinky@discussions.microsoft.com> wrote in message
news:85384478-B479-4FFE-8B97-465CE1C179EC@microsoft.com...
> 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" <luckyinky@discussions.microsoft.com> wrote in message
> > news:72D05C6E-87F5-4EB7-A30F-88BE74C0E038@microsoft.com...
> > > 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?
> >
> >
> >