Sum in Userform

[joacro]

Hi there,

I reposted this post as I didn't get an answer on my question

Hope someone can help me with a more logical solution on the question

I sorted the sum of txtbox, but now need to know how to sum everything:
ex:
input box and then a textbox which give a sum
Private Sub PHR_Change()
TextBox34.Value = PHR.Value * 2000
End SubI used this:

Now I need all the textBoxes to add up.

I have TextBox27 - 50 with above code and there value need to be summed in Textbox 51

I have tried the following:
Private Sub TextBox51_Change()
TextBox51.Value = Format(CDbl(Current.Value) + CDbl(TextBox27.Value) + CDbl(TextBox28.Value) + CDbl(TextBox29.Value) etc
End Sub

But with no luck.

Hope you can help

Regards
<!-- / message -->

 

[Andrew Poulsom]

Try using Val instead of CDbl.