VBA Basic Building Blocks
- If you found any of my free downloads or code useful and would like to support the website, or just say hello please consider buying me a cup coffee by clicking on the image above.
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.
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.