Calendar Made Using VBA Does Not Show Events for Last Week of the Month

[Rhizotz]

So I have created a calendar that can change month and year. It can also input events with the date attached to it. I will be referencing October 2022 when facing this problem. Whenever I have a month that has the final week in the 6th week (such as October 2022 or July 2023), if I input an event for the 31st, it will not show up in the calendar (only on the date sidebar). If I input something for the 30th, not only will it not show up on the 30th, it will input the event on every blank space that isn't in that month. For example in October 2022, the month starts on a Saturday and the Sunday-Friday before that should not have any dates with them as they are in September. It will paste the event continually from that Sunday to Friday.

[Pete_UK]

I could give you a calendar file which does what you want, only it uses formulae rather than VBA. Are you interested in this?

Pete

[remedina68]

Pete, I would be interested in your calendar app.

[Pete_UK]

I have presented several calendar files on the forum, each one geared to a particular poster's needs. Does your data really comprise just a date and event? How many events are you likely to have on any particular day? Are you likely to want to be able to specify a date range (i.e. from a start date to an end date for each event)?

Pete