What you are asking will not work. You have described the default behavior
and you can not get around that with macros (as macros will not execute while
a cell is in edit mode).
--
HTH...

Jim Thomlinson


"Jarle" wrote:

If I write text in a worsheet cell A1 Then:
[Alt + Enter] will insert Chr(10) - line break in cell A1
[Enter] activates the cell A2

It is possible to achive Chr(10) when I punch Enter.
I try to use cell a text input field.

rgds
Jarle