Excel VBA Calendar Tool

Excel VBA Calendar Tool
This is the Excel VBA Calendar tool that I developed for use with my To Do Manager Tool.  You can attach the tool to a button or invoke it by selecting the Ctrl plus q keys simultaneously.   It facilitates visually selecting dates. Excel VBA Calendar tool can also be used as a “‘popup calendar” to populate date text boxes in a form. (Make sure to set the form being populated to show modal = false). To download a free copy of my tool, please use the download button below.
Excel VBA Calendar Tool used as a popup for a form
I have the Excel VBA Calendar tool code set to populate the active cell with the date the user selects. We could, however, easily modify the code to act as a popup calendar selection tool.  If you select Ctrl plus the J keys, a simple 2 control form will open and by hitting the ‘cal’ button you can populate the text box.
Excel VBA Calendar Tool

If you enjoyed this post and would like to comment or share improvements please send your comments Here.  
If you would like to say hello and buy me a cup of coffee Click here.
Raymond Mills MBA, MS
Raymond Mills, M.B.A., M.S.  has spent over 20 years of his career as Accountant, Investment Bank and Credit Card Technical Auditor/ Data Analyst.  His specialty was using Excel to get Big Databases including Teradata, Oracle,  Squel Server and Sybase to give up their secrets.
Ray has said “I love nothing better than using VBA to unleash the power of Microsoft Office.” You can contact Ray @ 484 574-3190 or by emailing him Here

If you have a challenge with Excel, Access or Word and would like to speak with Ray,   You can get his contact details by clicking here: Contact Me

Comments are closed.