VBA Basic Building Blocks
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.