How to append text?

[dave8]

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]

In your code, you probably have something like:

Sheets("Data").Range("A1").Value = Textbox1.Text

Change that to:

Sheets("Data").Range("A1").Value = Sheets("Data").Range("A1").Value & " " & Textbox1.Text