Text Box help

[Exceldc7]

I have three text box. I’m looking for a formula to combine all three text box into text box number 4? Please help. I’ve not been able to come up with any kind of solution

 

[My Aswer Is This]

Are you wanting to add up all the values Like Result = 245

Or combine the Text Like JaneBobCharlie

 

[My Aswer Is This]

Try one of these:

Private Sub CommandButton1_Click()
'Sum values
'Modified  1/12/2019  12:51:21 AM  EST
TextBox4.Text = Val(TextBox1.Text) + Val(TextBox2.Text) + Val(TextBox3.Text)
End Sub
Private Sub CommandButton2_Click()
'Combine Values
'Modified  1/12/2019  12:51:21 AM  EST
TextBox4.Value = TextBox1.Value + TextBox2.Value + TextBox3.Value
End Sub

 

[Exceldc7]

Are you wanting to add up all the values Like Result = 245

Or combine the Text Like JaneBobCharlie

Im trying to combine text like Jane bob Charlie

 

[Fluff]

How about

Me.TextBox4.Value = join(Array(Me.TextBox1, Me.TextBox22, Me.TextBox3), ", ")

Change the comma space at the end to what ever you want as the delimiter.

 

[Exceldc7]

How about

Me.TextBox4.Value = join(Array(Me.TextBox1, Me.TextBox22, Me.TextBox3), ", ")

Change the comma space at the end to what ever you want as the delimiter.

thanks everyone for the help

Do i put this in as code or a formula?

 

[Fluff]

It's code that needs to go in the userform module, maybe on a command button as shown by MAIT, or under a textbox exit event on textbox3