Hi All

I have created a spreadsheet that uses a userform to enter data. The first field of the data is the date which I have set up as dd/mm/yyyy. Once the form is completed the USER presses the Add Record button and the VBA code places the data at the end of the current table.

I have the column set up in the spreadsheet as short date format dd/mm/yyyy.

The issue is for any day 1st to the 12th the date goes into the cell as mm/dd/yyyy however the format of the cell is still dd/mm/yyyy. eg 8th Sept 2015 goes in as 9/08/2015 and becomes 9th Aug 2015. Any date after the 12th works fine.

I have checked though my VBA code by adding msgbox's to see the value of the variable and even upto the line prior to the value being saved into the cell the Variable is correct.

I am adding the value to the cell with ".Cells(lRow, 1).Value = Me.pDate.Value" (see below)

Are there any suggestions as to how I can fix this issue.