Hi Experts,

I have a problem. When make use for format date it making my date as today's, how to retain the date which I had entered earlier.

Example:
Entered date as below: 13/11/2013
DOBBox.Value = Format$(Date, "DD/MM/YYYY")
Cells(LastRow, 19).Value = Month(DOBBox.Value)

saves the data as 18/12/2013, that today's date. Instead I need 13/11/2013 (which I had entered in my DOBbox text box.

Could anyone help in this regards?

Thanks in advance.

Pradeep