thanx Jim,
this is exactly what i wanted but can u also tell how to make the
cursor go down when i'm editing the cell.
so with onKey i can assign a new sub whenever enter key is pressed but
how do i write this syntactically in the sub i assigned, that i want
the cursor to go down and have a line feed. i tried vbcrlf but it does
not work.

TIA
regards