Userform textbox date sorting problem in main sheet

Hi,

I've got a userform that has a textbox that gets a date from the user. Then I use the following to store it in the location I want:

Please Login or Register  to view this content.

Then the code goes on to do other stuff and finishes with sorting the date in ascending order. However it doesn't sort the dates that are put in from the textbox and I can't even change the cell format to go to a general number. The only way I can do it is if I double click in the cell with the date and then press enter.. Driving me crazy..

Anyone got any suggestions?

Cheers,
Amoxia

You are a legend AlphaFrog!!!!
Worked like a charm. Thanks heaps!