Update calendar without using spinbutton

[Maleko-1]

Hello again,

I found a free excel event/planner calendar online that I downloaded. I am trying to modify it a little to fit my needs.

The workbook has the main "Calendar" worksheet that has a spinbutton to scroll through the months and another spinbutton to scroll through the years. The layout looks just like a calendar and when you change months or years the dates move to the correct day of the week. There is space within each date to add up to 7 events.

There is an "Events" worksheet that I have modified to use 3 columns (Date, Event, Number of Occurences. This information gets sent to the "Calendar" sheet.

I have added a commandbutton to the "Calendar" sheet that opens a Userform. A Userform commandbutton adds values to the 3 columns in the "Events" sheet.

The problem that I have is.....
The "Calendar" sheet will only update/show the new events if I click either of the 2 spinbuttons, whichs means that I have to click off the month or year and then click back to see the changes.

Is there a way that I can have this update/show the new events without having to click the spinbuttons?

Thanks again for any help you can give.
Marc

 

[p45cal]

It might be an idea to point us to this excel event/planner calendar.

 

[Maleko-1]

http://www.dotxls.com/excel-calendar-templates/free-excel-calendar-plus-with-holidays

This is where I picked up the calendar. Although you must click the "BUY NOW" to download, it is free. I hope this helps.

Thanks
Marc

 

[p45cal]

one problem here:
1. UNAUTHORIZED USE. You may not modify the SOFTWARE or disable any licensing or control features of the SOFTWARE except as an intended part of the SOFTWARE's programming features. You may not use, copy, rent, lease, sell, modify, decompile, disassemble, otherwise reverse engineer, or transfer the SOFTWARE except as provided in this agreement. Any such unauthorized use shall result in immediate and automatic termination of this license. The SOFTWARE can be copied by a registered user for personal use, backup purposes and for the purpose of creating additional sets of projections. Multi-user licenses are available from TechnoZero LLC.

 

[Maleko-1]

Hmmm, okay.
I definitely did not intend and do not want to create any trouble for myself.

So now I have created my own simple version of a planner calendar and came across the problem mentioned in my post . Is there a way to solve this?

As always any help would be much appreciated.
Marc