When you say "exits the sheet", it makes me think what you really need
is a userform with a textbox in it. e.g.

- Click button (say)
- Up pops a userform with a long, multiline textbox on it
- When you close the userform, your cells are populated.

Is this what you're after?

G

Greiffenberg wrote:
OK, thought I'd better be more precise about what I want to do...

I want a textbox on a sheet. The user enters text on it. When he exits
the sheet the text from textbox is copied to a cell, or rather to a
range of cells, because i would like the "copy to" cell shifts down
each time a cariage return appears.

In other words: I would like to make a macro that behaves exactly as
when I select the box text, copy it, select a cell and paste it...

Can anyone help/start me up?

Greiffenberg