With TextBox1
.Text = ""
.SEtFocus
End With

What do you mean by automatically?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B..." wrote in message
...
I have a userform where I put a total, It then copies to the cell I want
but
I need the textbox to clear so I can put another total straight back in
the
box. And also How do I get the Textbox.2 to update automatically


Thanks in advance

Greg