ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
On my userform i wish to copy values from various Textboxes & place in another TextBOx without overwriting the previous,
Example.
TextBox1 value HAPPY
TextBox2 value NEW
TextBox3 value YEAR
I have this code on one command button
It copies the value fine & places it in TextBox3 fine.
When i use the next command button to copy another TextBox value it places the value in TextBox 3 but overwrites the previous.
So it did show HAPPY but now just shows NEW
What code do i need to use to just keep what was there & paste the new value at the end
Example.
TextBox1 value HAPPY
TextBox2 value NEW
TextBox3 value YEAR
I have this code on one command button
Rich (BB code):
Private Sub CommandButton1_Click()
Me.[TextBox3] = Me.[TextBox1]
End Sub
It copies the value fine & places it in TextBox3 fine.
When i use the next command button to copy another TextBox value it places the value in TextBox 3 but overwrites the previous.
So it did show HAPPY but now just shows NEW
What code do i need to use to just keep what was there & paste the new value at the end