Plucky why you putting this:
text6.Text = Val(text1.Text) + Val(text2.Text) + Val(text3.Text) + Val(text4.Text)

in the text6_change event?