Sum of text boxes

[realgoldn]

I have 4 text boxes in a colmn and a total box at the end. The total box will be the sum of the values in textboxes 1-4. How do I get the total box to sum when alues are added or changed in any of the four boxes?

[Danial]

Originally posted by realgoldn
I have 4 text boxes in a colmn and a total box at the end. The total box will be the sum of the values in textboxes 1-4. How do I get the total box to sum when alues are added or changed in any of the four boxes?

Use javascript and write a function to AddUP the values of four text box. Use the OnChange event of each text box to update the calculation by calling the AddUP function.

[realgoldn]

Is there a way to have a group name for a group of text boxes. So I can say on change event of the group then call addup() or must I reference each textbox separatly cuase I have over 20 of them.

[Danial]

Originally posted by realgoldn
Is there a way to have a group name for a group of text boxes. So I can say on change event of the group then call addup() or must I reference each textbox separatly cuase I have over 20 of them.

No you cant group them, it wouldnt be much anyway just an extra line for each text box.

[realgoldn]

For some reason it is treating the value as a string not a number becuase the two values I want to add are 200 + 600 which is 800 but it is displau 200600. Help! This is the function!

sub AddUPEQP()
SET Add = document.Addproj
EQPTotal=add.txteqp1.value
EQPTotal=EQPTotal+add.txteqp2.value
add.txtEQP14.value=EQPTotal
end sub

[Danial]

Originally posted by realgoldn
For some reason it is treating the value as a string not a number becuase the two values I want to add are 200 + 600 which is 800 but it is displau 200600. Help! This is the function!

sub AddUPEQP()
SET Add = document.Addproj
EQPTotal=add.txteqp1.value
EQPTotal=EQPTotal+add.txteqp2.value
add.txtEQP14.value=EQPTotal
end sub

Use Val()........

sub AddUPEQP()
    SET Add = document.Addproj
    EQPTotal=val(add.txteqp1.value)
    EQPTotal=EQPTotal+val(add.txteqp2.value)
    add.txtEQP14.value=EQPTotal
end sub

[realgoldn]

Is it possible to call two different functions on the onchange() like this

onchange(addup(),totalup())??? Becuase I want to add the totals down and across so I need to different functions.

[Danial]

Originally posted by realgoldn
Is it possible to call two different functions on the onchange() like this

onchange(addup(),totalup())??? Becuase I want to add the totals down and across so I need to different functions.

Never tried it, it wouldnt be advised to do so. Have another function which call those to function, and call that function instead.

eg.

function myUpdate()
addup();
totalup()
end function

now simply call myUpdate.

Hope this helps.

Danial

[realgoldn]

Thanks!

[Danial]

Originally posted by realgoldn
Thanks!

You are welcome.