Sum of textboxes. Hopefully really simple

[buzz71023]

I have a calculator on a user form and i have most of the other math figured out but i need to know how to code the sum of textbox1 trough textbox 6. I've tried

textbox7.Value = textbox1.Value + textbox2.value + textbox3.value.......and so on

 

[Ruddles]

Unless I'm missing something obvious, that's exactly it. Didn't it work when you tried it?

Did it produce a compiler error? Did it produce a run-time error? Did it give an incorrect result?

 

[buzz71023]

yeah I had a run time error 13'. The first time I tried it it kind of worked, the other calculations worked great but the results came up to be

EXAMPLE
textbox2 RESULT = .10
textbox4 RESULT = .10
textbox6 RESULT = .10
textbox8 RESULT = .10
textbox10 RESULT = .10
textbox11 RESULT = .10

The sum of all in textbox14 = .10.10.10.10.10.10

 

[buzz71023]

He is what I have

txtRM1e.Value = (txtBlnd.Value * txtRM1.Value)
txtRM2e.Value = (txtBlnd.Value * txtRM2.Value)
txtRM3e.Value = (txtBlnd.Value * txtRM3.Value)
txtRM4e.Value = (txtBlnd.Value * txtRM4.Value)
txtRM5e.Value = (txtBlnd.Value * txtRM5.Value)
txtRM6e.Value = (txtBlnd.Value * txtRM6.Value)

txtTtlRM = txtRM1e.Value + txtRM2e.Value + txtRM3e.Value + txtRM4e.Value + txtRM5e.Value + txtRM6e.Value

 

[Ruddles]

Instead of TextBox.Value, use Val(TextBox):-

txtRM1e = Val(txtBlnd) * Val(txtRM1)
txtRM2e = Val(txtBlnd) * Val(txtRM2)
txtRM3e = Val(txtBlnd) * Val(txtRM3)
txtRM4e = Val(txtBlnd) * Val(txtRM4)
txtRM5e = Val(txtBlnd) * Val(txtRM5)
txtRM6e = Val(txtBlnd) * Val(txtRM6)
 
txtTtlRM = Val(txtRM1e) + Val(txtRM2e) + Val(txtRM3e) + Val(txtRM4e) + Val(txtRM5e) + Val(txtRM6e)

 

[buzz71023]

thanks, that fixed that problem...