Excel VBA Textbox Question

[markronz]

Hello everyone, I know this should be simple, but for the life of me I cannot figure it out. All I am trying to do is copy the text from one text box into another. This is my line of code which doesnt work...

Sheets("Type1").Shapes("TextBox2").Characters.Text = Sheets("Type1").Shapes("TextBox1").Characters.Text

What am I doing wrong?

 

[SkipVought]

Hi,

One way...
[tt]
Sheets("Type1").Shapes("TextBox2").OLEFormat.Object.Object.Text = Sheets("Type1").Shapes("TextBox1").OLEFormat.Object.Object.Text
[/tt]
Also check out how to use this tool to figure out what properties might work for an object.

How to use the Watch Window as a Power Programming Tool faq707-4594



Skip,

_[red][/red]