Date format error when coping from VBA to excel range

I am struggling to identify Date format error when copying from VBA to excel range. Please help.

I have an excel table ("tblJobList") acting as a database of current jobs and I am using dialog boxes to update the data including text boxes for dates. I use vba code to enforce UK format "dd/mm/yy". I have a problem that some dates end up the wrong format "mm/dd/yy" once they are copied into the excel range. NB it is inconsistent and some dates are in correct format.

Using the Local window to view the data structures I see that vaData(1,4) is type Variant/String but rgData.value2(1,4) is type Variant/Double

Below is the code extract.

-------------------------------------------------------------------

Please Login or Register  to view this content.