Accessing a textbox on a sheet....

  • Thread starter Thread starter Cyril
  • Start date Start date
C

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!
 
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 said:
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
Click to expand...
=---
 
Back
Top