Date and Time Picker Tool in Excel
Entering dates and/or time, depending on the format of the date and time picker tool, you can make your work more productive.
In the design mode you can change the properties of the date and time picker tool under ‘format’. Here you can set the property to ‘date’ or ‘time’ or create a custom format.
You can also refine the macro code to do more but our main aim was to introduce you to the date and time picker tool at the moment. The training video describes the process in Excel.
As you have observed it takes only a few clicks and a single line of code to implement the date and time picker tool feature
Just ensure that you use the right variable names!
Watch the training video. No sound!
How to use date time picker in excel 2007