Hello,
I have a form which puts a date into a cell, however I have a slight problem with it...
If the date within the form says 15/08/2010, then 15/08/2010 is displayed in the cell.
However, if the date within the form says 06/08/2010, then 08/06/2010 is displayed in the cell.
Why does the cell display the correct date if it is after the 12th in the month, and the wrong date (back to front) if it is the before the 13th of the month?? This doesn't make sense to me?
Any help would be much appreciated.
LSM1604
Below is a small section of my code:
I have a form which puts a date into a cell, however I have a slight problem with it...
If the date within the form says 15/08/2010, then 15/08/2010 is displayed in the cell.
However, if the date within the form says 06/08/2010, then 08/06/2010 is displayed in the cell.
Why does the cell display the correct date if it is after the 12th in the month, and the wrong date (back to front) if it is the before the 13th of the month?? This doesn't make sense to me?
Any help would be much appreciated.
LSM1604
Below is a small section of my code:
Code:
Range("Q5").Select
With ActiveCell
.NumberFormat = "dd/mm/yyyy"
.Value = TextBox_DateHidden.Value
End With