Accessing a textbox on a sheet....

[Cyril]

I have a sheet that has two text box objects called Text Box 1 and
Text Box 2. How can I copy over information to those in VBA?

Thanks!

 

[Tom Ogilvy]

assuming the textbox from the drawing toolbar:

With Activesheet
.Textboxes("Text Box 1").Text = .TextBoxes("Text Box 2").Text
End With

Regards,
Tom Ogilvy

I have a sheet that has two text box objects called Text Box 1 and
Text Box 2. How can I copy over information to those in VBA?

Thanks!


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---