Sort issues while using userform

greetings,

i have a worksheet with a userform, which i am having issues with. when the userform fields have been filled in and then submitted, on sheet1 it properly enters the information onto the sheet. the problem is that the date (which needs to be in the format of mmmm d) does not sort as it should. it will only sort if i manually select the date cell of the last entry on sheet1. Once i select the date cell, the sheet is correctly and immediately sorted. on sheet1 in visual basic, i have code that deals with the change in sheet data that should initiate the sorting. my goal is that i would like for it to automatically sort once the submit button is pressed on the userform.



any help would be greatly appreciated! i am unable to come up with a solution to this problem



see attached file

after moving the worksheet_change code to a regular module and then try to call the sub from the userform, i get an error "compile error: argument not optional". any help would be appreciated.

I never complain when the projects work! Thanks so much for cleaning up the code and fixing my mess. Works like a champ!

david

Hello.
It is common for some things to not work properly in some PC locales.

And that is the case of the introduction of the dates in the cells: I enclose a way to give generality to the topic.

Please Login or Register  to view this content.