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!
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.
Feel free to download the Excel Calendar generator here:
Be sure to share your feedback in the comments below or on my Social websites!