Excel Calendar Generator - generate calendar in Excel VBA

It is 1 day before the end of 2015 hence I thought it might be interesting to create an automatically generated Excel Calendar using VBA that I could populate with holidays, anniversaries and other recurring events. But why repeat this manual process every year when we can force Excel VBA to do the work for us and knock up a Visual Basic Macro! Today’s goal: building an automatically generated Monthly Calendar using Excel VBA!

Excel Calendar: The result

Let’s start from the back – what we need is a Monthly Calendar that would generate automatically for any given year. Apart from that let’s also to be able to:

Add Holidays – provide month and day
Add custom dates such as anniversaries, birthdays, appointments etc. – again by just providing the month and day, and make sure that dates with more than one record with stack them row by row

The Excel Calendar generator needs to be reusable every year and require as little work as possible to copy our holidays and dates to the next year. This is my example for July 2016:

Generating the Excel VBA Calendar

Let’s have a look at the Excel VBA Calendar generator and how it works. It all comes down to 5 Easy Steps!

Settings

Start by providing the Year for which you want to generate the calendar, the First day of the week and… your Language. Yes! – the Excel Calendar will appropriately name the Months and Days of the week in the language of your choosing.