Display text box contents in cell

[Guest]

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?

 

[Jim Rech]

I know that there is a way to display cell contents in a text box but I
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
|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!