hi all,

date in the excel have some problems when i wtire 14/01/2007 it
chenges sutomatically to "01/14/07. i did change it from the
Formatcell and from Control pannel regioanl sitting, but the problem
still exists.

thanks

Hi Abid

you could try using cdate i.e.

Private Sub CommandButton1_Click()
mydate=textbox1.value ' add 01/03/2007 to the textbox then press the
button
[A1].Value = CDate(mydate)
End Sub

for more information on cdate search excel help or this newsgroup...
the mighty tom ogilvy has a wealth of posts explaining this

hope it helps

S