Macro to [ALt]&[Enter] Whilst Typing

You can't, I'm afraid.

Thank you for replying

Roj47 said:

Part of me thinks this is being lazy, ...
... I am having trouble pressing Alt and Enter in a cell to insert a new line

Click to expand...

No way, that's not lazy at all!

Well, one way is to use Autocorrect.

Ex., use the sequence "||" to be replaced with the newline (or any other sequence you want).

Execute:


Now write in a cell "abc||def". You'll see that the newline is inserted automatically.

Is this a good solution?

Thank you for the code, but I am unsure where to locate it to run automatically.

I attached it to the tab as :

Sub Copy_Formula()
Private Sub Worksheet_Activate()
Application.AutoCorrect.AddReplacement "||", Chr(10)
End Sub

But it would not work.

I know I am a bit slow, but starting to understand.

From what you have written it is perfect for what I am in need of and of course the || could be replaced with a differing symbol that I never use.

Kind regards