Does anybody know a formula (not VBA) to get text from a text box to a cell?

I can get text from a cell to the cell box, but is it possible the other way around?

Greiffenberg