Copy / Link Textboxes between Files
 

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.

Copy / Link Textboxes between Files
 

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").OLEObjec ts("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.