VBA: cell combining two textboxes
Solved
Hello,
I wanted to know if it was possible to copy the values of two textboxes from the same form into a cell of my table. Let me explain: my Userform1.textbox1 = A, my Userform1.textbox2 = 18. How can I make my cell (let's say A1) equal to "A 18"?
Thank you in advance for your responses.
I wanted to know if it was possible to copy the values of two textboxes from the same form into a cell of my table. Let me explain: my Userform1.textbox1 = A, my Userform1.textbox2 = 18. How can I make my cell (let's say A1) equal to "A 18"?
Thank you in advance for your responses.
Configuration: Windows XP / Internet Explorer 6.0
2 answers
-
ModeratorHello,
Simply like this:[A1] = UserForm1.TextBox1 & UserForm1.TextBox2
If you want a space between A and 18:[A1] = UserForm1.TextBox1 & " " & UserForm1.TextBox2
--
Best regards,
-- Every problem has its solution. If there is no solution, where is the problem? -- -
Thank you very much, Pijaku!!!
