Concatenate values from Text Boxes into 1 cell not working

Hi everyone,

in my userform I have 3 textboxes and I want to combine the values in these boxes and show it in sheets("Test") cell A1.
I found a macro and I have tested it and tried some changes but I have no luck.
Can you please help me finding why it is not working?
The Boxes are named txt1, txt2, txt3.

Please Login or Register  to view this content.

Thanks a lot
Kind Regards
Roman

Hy TMS,
thanks for the code but I get an error at
sConcat = sConcat & Me.Controls(csTBName & i).Value

Kind Regards

Sorry, I found my mistake.

Everything works.
Thanks a lot