I have a simple userform that builds a calender on formulas with VBA for several listboxes and a combobox (CmbYear) for selecting the year. The CmbYear combobox allows user entry, but when I enter a value and click the X to close, the Invalid Property Value message appears. It continues until I click the combobox arrow and select one of the years in the list. I shut off the X close function and added a close button, but the error still appears whenever a manual entry is made in the combo box.
I tried a few remedies found online, such as setting the listindex to 0, but that and others didn't work. I have the list max length set to 4 to prevent entry of more than 4 characters, but this doesn't prevent the error.
The file is attached. Help will be greatly appreciated.