Auto result of 4 TextBox value after multiplication

[abid]

Hello Friends,

I want to know how can I get result of 4 TextBoxes on 5th textBox after multiplying the values of 4 TextBoxes ?

textbox5 = TextBox1 * TextBox2 * TextBox3 * TextBox4

Can anyone help me out with the Script ?
you help will be highly appreciated

Thanks

 

[Sahak]

Hi Abid,

Try this:

Private Sub CommandButton1_Click()
    TextBox5.Value = Val(TextBox1) * Val(TextBox2) * Val(TextBox3) * Val(TextBox4)
End Sub

 

[abid]

Thanks for the help. I really appreciate it.

If I am looking for a result which is based of average. i.e

40 + 40 + 40 + 40 = 160 /4 = 40

if I need to do this calculation how can I do that ?

 

[doofusboy]

You could try this for the average:

Private Sub CommandButton1_Click()
    TextBox5.Value = [COLOR=red][B]([/B][/COLOR]Val(TextBox1) [COLOR=red][B]+[/B][/COLOR] Val(TextBox2) [COLOR=red][B]+[/B][/COLOR] Val(TextBox3) [COLOR=red][B]+[/B][/COLOR] Val(TextBox4)[B][COLOR=red])/4[/COLOR][/B]
End Sub

 

[abid]

Thank you for your help.
its working as what I wanted.

 

[abid]

I have one more query, if anyone can help me with it please.

I want to put a condition

Textbox1 = Val(textbox2) - Val(TextBox3)

if it results in -00 then Textbox1 should result "Blank" unless the result is in +00 it doesn't show the result.

 

[Sahak]

Please give an example.