trainwater
New Member
- Joined
- Jan 25, 2016
- Messages
- 4
I have a textbox on Worksheet A. The textbox name is TextboxB. I am trying to use VBA to add text to the end of the textbox without overwriting the text that is already in there. Please keep in mind these are textboxes on worksheets that are shapes, not controls.
Using the following put's the text in , but deletes all other text first.
This is what I want to happen
TextBox A (pre code run)
|***********************|
| This text is here |
| |
|_______________________|
TextBox A (post code run)
|***********************|
| This text is here |
| New Text |
|_______________________|
Using the following put's the text in , but deletes all other text first.
Code:
worksheets("A").Shapes("TextBoxB").TextFrame.Characters.Text = "New Text"
This is what I want to happen
TextBox A (pre code run)
|***********************|
| This text is here |
| |
|_______________________|
TextBox A (post code run)
|***********************|
| This text is here |
| New Text |
|_______________________|