Search results for query: *

Skip, You put me on the right track and I have it figured. Thank you very much. By the way, I am calling the TextBox on the last page (the Summary page) "TextBox3" and it works fine. Thanks again,

Gerry, I think you are on to something. The fact that textboxes on each page start being numbered again is not obvious to a newbie like me. And I am not using the variables, they didn't work. Also, I suppose it will make a difference if the textbox properties are locked in any way?? I have...

Skip, Thanks for your time and effort. when I run your code I get a runtime error, '438' 'Object doesn't support this property or method'. And it activates on the line of code With Worksheets("Description").Worksheets("Summary") Any other ideas?? Thank you again.

I tried your solution with the Dim t1, t2, and I get an Error msg '9', "Subscript out of range" message??

This is the exact code, Option Explicit Sub Text_Copy() With Worksheets("Description") Worksheets("Summary").Shapes("TextBox3").TextFrame.Characters.Text = .Shapes("TextBox1").TextFrame.Characters.Text & " " & .Shapes("TextBox2").TextFrame.Characters.Text End With End Sub ANd it...

BEfore I try that, what about this. This file is initially saved as a template (.xlt) file. This code works if I right-click and open the template and enter data, but when I just double click and open, causing it to open as an .xls file, it doesn't work.

Sorry, that was an error in my typing skills, it isn't actually there in the real code.

No, no error message, it just doesn't place the text in the proper textbox!!

Using Office 2000, here is the code I am using which works on my laptop with Office 2007. (The textboxes are inserted textboxes not from a userform). CODE Option Explicit Sub Text_Copy() With Worksheets("Description")...

Wimvh, I just tried your latest suggestion and it doesn't work. I get a method doesn't work with object error message. ??

Thanks wimvh, that is a nice easy solution. Now I have a couple. but it is all valuable learning.

Thank you much for the code, however I am running Windows Vista (not sure if that matters or not) and that code keeps giving me the debug error, saying Here is my full code; runtime error 438, object doesn't support this object or method. Private Sub Workbook_Open() Worksheets("Summary...

I am trying to figure out how to copy the text that is contained in two different text boxes in an excel sheet and combine and concatenate that text into a third textbox on a different sheet in the same workbook. Any quick code ideas would be greatly helpful.