I know that there is a way to display cell contents in a text box but I
would like to do just the opposite.

There is no equivalent way built into Excel. As always in cases like this
you'd have to write a macro to do what you want.


--
Jim
"msandomir" wrote in message
...
|I have a text box that users input text on a weekly basis. How can I
export
| a copy of the text box contents into another cell on another worksheet.
For
| example, I know that there is a way to display cell contents in a text box
| but I would like to do just the opposite.
| Does anyone know of an automated way to do this?
| --
| Thank you!