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! |
|
|