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:
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..Please Login or Register to view this content.
Anyone got any suggestions?
Cheers,
Amoxia
Bookmarks