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.
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.
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.