The exact forumla that I am using is as follows

=worksheets("Proposal").Textboxes("ProposalText"). Value=worksheets("Estimate").Textboxes("EstimateTe xt").Value

and I continue to receive an error message stating: "Refernce is not valid.

--
Thanks,
Marc Shaw


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy



"Marc Shaw" wrote:

Thanks Tom,

Is it possible to go from a text box on one sheet to a text box on the other
sheet?
--
Thanks,
Marc Shaw


"Tom Ogilvy" wrote:

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