I am trying to copy all the data out of one text box in file A and put it in
a different Textbox in file B, similiar to if it were a linked cell from file
to file, only with textboxes. These are large textboxes (over 255) so I was
hoping to avoid moving the data out of the textbox to the page and then
importing (via a linked cells) in File B and then refilling the textbox. Was
curious if anyone has a better method.

Thank you.

Are the textboxes on a userform or a worksheet. Do the textboxes have the
same names?

Here are two methods

boxdata = Workbooks("textbox.xls").Sheets("Sheet1").textbox1.Value

boxdata =
Workbooks("textbox.xls").Sheets("Sheet1").OLEObjects("textbox1").Object.Value

"Troubled User" wrote:

> I am trying to copy all the data out of one text box in file A and put it in
> a different Textbox in file B, similiar to if it were a linked cell from file
> to file, only with textboxes. These are large textboxes (over 255) so I was
> hoping to avoid moving the data out of the textbox to the page and then
> importing (via a linked cells) in File B and then refilling the textbox. Was
> curious if anyone has a better method.
>
> Thank you.