Set-Up Holiday Team Calendar

Dear all,

I wanted to create a Team Holiday Calendar using the Combo Box function. This way the team can switch to the different months and add there holidays.
So far I was able to insert the Combo Box function and wrote a short code. Now if I insert "x" in one of the months and I want to go to the next month all data disappears in my worksheet (that's good) but when I want to go back to the month where I made the changes, the changes disappeared as well. I still want to be able to see what I have entered in each month without the adjustments being transferred to another month . How do I need to change the Macros of my excel file?

This is the Macro that I have at the moment:

Please Login or Register  to view this content.

I'm not sure what I need to add so that the Data is storaged in each specific month.
Thanks a lot for your help!


Kind regards,
Sam

Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.

You have posted in the Access DB sub forum. Is this for an Access Data Base or an Excel Workbook?