In this lesson I'm going to teach you how to overcome formatting errors when you input data to excel sheet from a text box, combo box etc.
Here is a my own experience. Once I had a date value 01/08/2014 in one of text box of a user form.I got that value to the text box from a date picker. So it was in the format dd/mm/yyyy.
So the above date refers to 1st of August 2014.
However when data entered to the excel sheet it took the form of 08/01/2014
So now it refers to 8th of January 2014
If you face this kind of situation here below is the solution.Just format the value using Format function before input data to the sheet.
Here txtDueDate is the name of the text box. Below example enters date value to cell E3 of worksheet("Data")
|
Dim WS as worksheet set WS=worksheets("Data") Dim DDate As Date DDate = Format(txtDueDate.Text, "dd/mm/yyyy") WS.Range("E3").Value = DDate |