| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
|
#2
Posted to microsoft.public.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 "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 =--- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link a textbox on a sheet to a cell?! | Excel Discussion (Misc queries) | |||
| Accessing Other Sheet Tabs from within Excel | Excel Worksheet Functions | |||
| How can i import data from a cell in another sheet, into a textbox | Excel Worksheet Functions | |||
| Problem seeing and accessing top of sheet | Excel Discussion (Misc queries) | |||
| Textbox changes position on a copied excel-sheet | Excel Discussion (Misc queries) | |||
![Cyril[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
