VBA Remove blank space

[Aretradeser]

I use a UserForm with several controls for data entry to an Excel sheet.
In one of the columns of this sheet, I enter the values of 3 linked TextBoxes: the first 2 values (TextBox2 and TextBox3), separated by a blank space. The third value (TextBox1), separated from the value of TextBox2 by a ",". The issue is that between the TextBox3 value and the "," there is a blank space and I need it not to be like that; that is, the last letter of the TextBox3 value to be followed by the "," with no blank spaces.
The values of the 3 TextBoxes are text.

CODE:
With Worksheets("DATA")
            t = Cells(Rows.Count, 2).End(xlUp).Row
            Cells(t + 1, 2) = TextBox2 & " " & TextBox3 & ", " & TextBox1
            Cells(t + 1, 3) = ComboBox5
            Cells(t + 1, 4) = ComboBox6

 

[Fluff]

That sounds as though you have a space at the end of value in textbox3

 

[SQUIDD]

There is a space in your code

 

[SQUIDD]

& ", "

& ","

 

[Fluff]

The OP said

the last letter of the TextBox3 value to be followed by the ","

That blank you are removing is after the comma & not before.

 

[SQUIDD]

Oh no. Sorry. I miss read.

Yes I would agree with fluff.

Would trim(textbox3) work.

 

[Fluff]

Would trim(textbox3) work.

Should do.

 

[SQUIDD]

The OP said

That blank you are removing is after the comma & not before.

Yes sorry. I spotted that less than a second after posting ?

 

[SQUIDD]

just incase

With Worksheets("DATA")
            t = Cells(Rows.Count, 2).End(xlUp).Row
            Cells(t + 1, 2) = TextBox2 & " " & trim(TextBox3) & ", " & TextBox1
            Cells(t + 1, 3) = ComboBox5
            Cells(t + 1, 4) = ComboBox6

 

[Aretradeser]

Should do.

Thank you for your reply and for the correctness of your answer.