Hello,
I've made a userform with text box for entering data and a text box to put a date in. When I use this, excel won't organize the dates properly. It either thinks they are text and suggests from A to Z or tries to organize them by date, but fails; the years won't be in proper order. So what should I do to make it organize them properly? I've gotten to a point where the text box fixes dates, eg. if I put in 3.4.11 it changes it to 03.04.2011, but still won't organize.
I've made a userform with text box for entering data and a text box to put a date in. When I use this, excel won't organize the dates properly. It either thinks they are text and suggests from A to Z or tries to organize them by date, but fails; the years won't be in proper order. So what should I do to make it organize them properly? I've gotten to a point where the text box fixes dates, eg. if I put in 3.4.11 it changes it to 03.04.2011, but still won't organize.