Change Date Formats

I have a userform which allows data to be entered onto a worksheet. One of the fields (a textbox with the standard calendar control) is the date. When the transaction saves, it correctly saves the date as dd/mm/yyyy using

ActiveCell.Value = TxtDate.Text

I also have a form which allows the user to amend a transaction by loading the data onto the form, amend it and save it back to the worksheet.

The problem is that when it picks up the data and re-saves it, it's resaved in the format mm/dd/yyyy which is a problem because I use the month as one of the categories that users can filter the data by.

I also have the following line immediately after each time the data is saved from the form to the worksheet:

Selection.NumberFormat = "dd/mm/yyyy;@"