Calendar control for Excel VBA
There is not a calendar control in Excel VBA, so I made it.
It can be downloaded from the following link.
The following figure is the calendar control I made. A left form is a sample to test it. When “Run” button is clicked, Calendar is shown. When a date box in Calendar is clicked, a date value is returned in TextBox
As event processing of “Run” button, It’s only enough to write the following 3 lines code.
Not only TextBox but also Label can be used.
As a characteristic function, date value can be put in Sheet Cell. The folloing is a example.
The source code is following: