Userform Date Swapping Issue

I have a userform that searches for a particular row on my spreadsheet. It then allows me to update the data using the necessary textboxs and then update that specific row by clicking a button. All seems to be working fine, except the date text boxes, which are swapping the day and month fields. (e.g. 01/02/1999 becomes 02/01/1999). I had a similar problem on another sheet and fixed this problem using CDate, however I cannot seem to get this to work for this instance.

Below is the code I am using to "update" the spreadsheet and the specific lines causing me issues are "ws.Cells(r.Row, 12).value = txtCriticalDate.Text" and "ws.Cells(r.Row, 15).value = txtCompleteDate.Text"

Any help on this would really be appreciated.

Please Login or Register  to view this content.

~~SOLVED~~

Posted literally 2 minutes too soon and worked it out. For anyone with a similar issue,

Please Login or Register  to view this content.

worked