Private Sub TextBoxVIEADH1_change()
TextBoxVIEADH1 = Format(TextBoxVIEADH1, "#,##0")
TextBoxVIEADH3 = Val(Replace(TextBoxVIEADH1, [COLOR="Red"]Chr(160)[/COLOR], "")) + Val(Replace(TextBoxVIEADH2, [COLOR="red"]Chr(160)[/COLOR], ""))
End Sub
Private Sub TextBoxVIEADH2_change()
TextBoxVIEADH2 = Format(TextBoxVIEADH2, "#,##0")
TextBoxVIEADH3 = Val(Replace(TextBoxVIEADH1, [COLOR="red"]Chr(160)[/COLOR], "")) + Val(Replace(TextBoxVIEADH2, [COLOR="red"]Chr(160)[/COLOR], ""))
End Sub