Absolute Calender Program!

[Preeti Verma]

Use of calendar progran in astrology requires it to be backward/forward compatible by few thousands years...or even more.
..
Do we have a code for this unlimited calendar program wherein user enter AnyYearTextInTheCell & generates entire 12 month calender for that year?

Here, user don't want to use combo tool for year selection but numeric only TextBox for accepting years text [Dim yrText As Long]. Unlike MS default 10000 yrs calender, should have no defined upper/lower years limits but VBA_DataTypeLimits for LongData only.

[technicalupload]

Hi Preeti :: How are you doing?

This can be done using following code, click on the hyperlink. (little tweak required), Excel Macro VBA - Create a 12 Month Calendar With The Current Day Highlighted in Excel - Free Excel Macros VBA - TeachExcel.com (http://www.teachexcel.com/free-excel-macros/m-145,create-calendar-12-month-excel-macro-free.html)

I am bit busy in some work, let me know if incase you are unable to change as per your need

Regards: A.S.