I see from the userform that you have a date field AND a combobox to choose the sheet; wouldn't it be feasible for the user to enter a date and have the code work out what sheet the data should go into?
I left a response to your other thread - your answer there could impact this thread.
Could you do a little test for me? I've added a DateTime Picker control to the top left of your userform, could you do a 'userform1.show' and try and select a date in the date picker and tell me if it works, what's more it should also enter a date into the date field; does that work too?
Bookmarks