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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>