BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

Monthly Calendar Planner Template




Tonight, I tried my hands on calendars and planners and sure, I come up with an elegant calendar which can be used as planner too but agree many of you won't consider it as a perfect one.

So, I'll refine it more but instead of directly jumping to that, I advise Excel users and my readers to go through this version and see, how it is prepared. There is so much learning in it, you'll surely get benefit from it.

Watch this Calendar Dashboard for:

  1. Named Ranges
  2. Range Linked Picture (Copy Range --> Paste as Picture Link, also known as Camera)
  3. Conditional Formatting
  4. Arrays
  5. Combo Box (Active X Control)

Click here to download the Monthly Calendar Dashboard.