Accessing a textbox on a sheet....
 

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 =---

Accessing a textbox on a sheet....
 

assuming the textbox from the drawing toolbar:

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

Regards,
Tom Ogilvy


"Cyril" wrote in message
...
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
=---