Copy and paste from textbox to worksheet

[NJH88]

Hello, just wondering if someone can help me please. I have a 3 userforms with textboxes and command buttons. When the user clicks the last command button on each userform all the data from the textboxes on that userform are concatenated and put in a string on a worksheet (sheet4). This works fine for userform1 as i simply state i want it pasted in rangeA2 on sheet4. However, when i do the same for userform2 and 3 I want this data to be pasted in sheet 4 straight after the last character that was pasted from userform1. I cant just say paste in location of cell A2 for example because each character does not have its own cell, its just simply pasted in a long string. Does anyone know how i can state the location so that the string from userform2 can be pasted in following on from the userform1 data?

Thankyou for any help

[TMS]

You'd need to concatenate the values. Something like:

Please Login or Register  to view this content.

Regards, TMS

[NJH88]

Thankyou this has worked!!

[TMS]

You're welcome.