TRnasferring date form userform textbox to cell in worksheet

Hi all

I have a userform with numerous text boxes. One textbox is used to input a date with the following code

Please Login or Register  to view this content.

When I have completed my userform I want to export this date as a date into range(a2) so I can then use the filter function to filter by month or year. THe problem I am having at the mo is that in the userform it is formatted as dd mm yy, but when I export it from userform it changes to mm,dd,yy. So if I entered 12th January 2014 it changes it to 1st December 2014.

Any help on this would be greatly appreciated.

A workaround is to export as text but then I use the filter by month year function so would prefer to avoid this.

Cheers in advance

change the formatcells of (A2) is Text instead of Date: