I have created a calendar control on a form in Excel and everything works
fine except for one thing. When the user selects a different month from the
drop down, I want the day to stay the same as the previous day that was
selected. I have tried several different methods, but the day remains empty
and unselected. Nothing I have tried seems to work.

Any suggestions will be appreciated.

Thank you