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 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    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