PDA

View Full Version : Why won't this (simple) VBA work??



marshman99ca
04-21-2007, 10:38 AM
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")
Worksheets("Summary").Shapes.("TextBox3").TextFrame.Characters.Text = .Shapes("TextBox1").TextFrame.Characters.Text & " " & .Shapes("TextBox2").TextFrame.Characters.Text

End With
End Sub

I appreciate any help.

mudraker
04-22-2007, 05:22 AM
marshman99ca

When posting VBA code forum rules are that you wrap it in VBA tags by using the VBA button


Re your problem
Remove the . from this part of the code

Shapes.("TextBox3")


I can not test your code to verify that there is nothing else wrong