How to append text?

dave8

Active Member
Joined
Jul 8, 2007
Messages
264
I have a textbox used as a comment. This textbox on a form writes to a cell on a worksheet. For example, I type, "Hello World" in the textbox. "Hello World" gets copied to cell "A1" on another worksheet. How do I append the text, "Hello World", to what is already in cell "A1"?
 

mvptomlinson

Well-known Member
Joined
Mar 10, 2008
Messages
2,638
In your code, you probably have something like:
Code:
Sheets("Data").Range("A1").Value = Textbox1.Text
Change that to:
Code:
Sheets("Data").Range("A1").Value = Sheets("Data").Range("A1").Value & " " & Textbox1.Text
 

Forum statistics

Threads
1,082,446
Messages
5,365,567
Members
400,838
Latest member
Renedescartes

Some videos you may like

This Week's Hot Topics

Top