userform textbox to hold and add to existing data

[bqheng]

Hi, I have this userform with a textbox16 on the "add case" tab. What im hoping to achieve is for this textbox to hold on to data that has been added to it when the "Add" command is clicked. For example, after filling in the info in combobox6, textbox 6 and 15, clicking "Add" will add those info into textbox16 and clear the info from combobox6 and textbox6 and 15. Repeating this process should not clear what has been previously entered into textbox16. Ultimately, textbox16 should look like this:

Body part X1234 M5678
Muscle X2345 M7890
Tooth X3456 M1232

I do not know if this is possible, but any help would be appreciated. Attached is the workbook for your reference

[mikerickson]

Something like

Please Login or Register  to view this content.

[bqheng]

Thank you mike. How do I make it such that it goes into a line break after each time it executes?

[mikerickson]

What do you mean "goes into a line break". The code I posted puts the a linebreak before the new line in the text box.

[bqheng]

this is how it looks like after clicking the command button. Can the second entry go into another line instead of continuing in the same line?

[mikerickson]

It looks like you need to set the TextBox's .MultiLine property to True.

[bqheng]

Thanks mike, that solved the issue. One question, is it possible to have the different lines in that textbox go into different rows on the worksheet?

[mikerickson]

Yes. If you want the text box values to go into A1 and downward

Please Login or Register  to view this content.

[bqheng]

Thanks mike! I have problems making the code work in the actual workbook that I have, but will post another thread so that this one doesn't go off topic. I hope you will be able to help me again there thread link as below

http://www.excelforum.com/showthread...78#post4490378