No - that is what I said. A macro will not run when you are in Edit mode.
Onkey assignments do not work when you are editing a cell.

--
Regards,
Tom Ogilvy

"helpwithXL" wrote in message
oups.com...
hi Tom,
thanx for reply. do you think that with the onKey method is it possible
to assign a macro, when the enter key is pressed, but then the pressing
of enter key has to be captured while editing the cell and then with
onKey method, a macro may be executed and this macro only feeds a line
in the cell and leaves the cell back in edit mode.

TIA
amit