Textbox3.Text = Format((cdate(textbox2) - cdate(textbox1),"0")

removed the control source setting from you textboxes.

--
Regards,
Tom Ogilvy

"timh2ofall" wrote in message
m...
I'm trying to build a Userform Date calculator where you would enter a
begin date in TextBox1 and an end date in TextBox2. CommandButton1
would then subtract the value in TextBox1 from TextBox2 and display
the number of days in TextBox3.
I tried having TB1 and TB2 place their values onto sheet1 A1 and A2
with a sum formula in A3. I then assigned the ControlSource for TB3 to
Sheet1!A3. It works only one time and then clears out the formula in
Sheet1 A3.
Can anybody help?