You can set the Linked Cell in the textbox properties. That way, textbox and
cell will always be the same, whichever one you change.

--
Ian
--
"Greiffenberg"
wrote in message
news:Greiffenberg.1sd3uf_1121684715.5021@excelforu m-nospam.com...

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


--
Greiffenberg
------------------------------------------------------------------------
Greiffenberg's Profile:
http://www.excelforum.com/member.php...o&userid=25311
View this thread: http://www.excelforum.com/showthread...hreadid=387954