worksheets("Proposal1").Range("F12").Value = _
Worksheets(Sheet1").TextBoxes("Text Box 1").Value

where Text Box 1 is a textbox from the drawing toolbar.

--
Regards,
Tom Ogilvy



"Marc Shaw" wrote:

I have a worksheet that I would like to be able to enter freeform text
(Possibly a text box) into an estimate then have that text transfer to
another worksheet to be entered into the body of a proposal. Is this
possible and if so, how?
--
Thanks,
Marc Shaw