Excel Programming >> 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.hide-link.com/ The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
Excel Programming >> 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
> 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
=---
