Adding two or more cells for a TextBox value

[gheyman]

Is there a way to have a TextBox equal the values of two or more cells added together

I tried this, but it just concatenated the two values and didnt add them.

TextBox155.Value = Sheets("Pricing Sheet Compilation").Range("R27").Text + Sheets("Pricing Sheet Compilation").Range("R28").Text

 

[VoG]

Try

TextBox155.Value = Val(Sheets("Pricing Sheet Compilation").Range("R27").Text) + Val(Sheets("Pricing Sheet Compilation").Range("R28").Text)

 

[2011everafter]

I have a user form that has 4 textboxes ( textbox 1 , 2 , 3 , 4 ).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>

textbox1 is entered by the user.<o></o>
textbox2 is entered by the user.<o></o>
textbox3 is extracting the value from a sheet cell.<o></o>
textbox4 is extracting the value from a sheet cell ( that is the sum of all the 3 boxes).<o></o>
<o></o>

The problem is that , in order to display the correct value in textbox4 I have to exit the userform and call it again.
<o></o>
<o></o>
It is not dynamically updating textbox4 as they are entered in the textbox1 and 2, and textbox3 value extracted from the sheet cell.
<o></o>
Any workaround to this ?<o></o>
<o></o>
Thank you.<o></o>
<o></o>