A simple macro to use the date and time picker tool in Microsoft ExcelEntering 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. |
![]()
Custom Search
|