Date Time Picker Tool Excel 2003 VBA

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
activecell.value=DatePicker.value
Just ensure that you use the right variable names!

Watch the training video. No sound!

 

More info:
How to use date time picker in excel 2007

Leave a Reply

Your email address will not be published. Required fields are marked *