Yes,

you could add

TextBox3.Text = Format(CStr((Val(TextBox1.Text) + Val(TextBox2.Text)) *
0.175), "#,##0.00")

to each textbox change event and dump to the worksheet as with the other
amounts

Worksheets("Sheet1").Range("K2").Text = Textbox3.Text

--
HTH

Bob Phillips

"mully" wrote in message
...
Hi

On a user form I have 2 Text Boxes in which to enter cash figures
Excluding
TAX - on the worksheet these 2 figures enter columns E & G - in column K
I
have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new
Text Box on the user form could it generate the Tax as the formula above
and
then on clicking Add Iformation Button it would enter column K thus doing
away with the formula in column K on the worksheet which is sometimes
altered
by mistake.

Any help much appreciated

Cheers ---- Mully