View original (French)

VBA: cell combining two textboxes

Solved
JFK -  
 JFK -
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.
Configuration: Windows XP / Internet Explorer 6.0

2 réponses

Réponse 1 / 2
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 771
 
Hello,
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? --
2
Réponse 2 / 2
JFK
 
Thank you very much, Pijaku!!!
0