Hi funkymonk,

this should solve your problem

Sheet1.Range("A1") = DateValue(TextBox1)

So even if textbox1 has a date like 22/2/2005, excel will correctly
interprete it. But I guess the probelm will remain in dates like
5/2/2005

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374123