How to create a named range for a time picker control
To create a named range for a time picker control;
- Open your Excel workbook,
- Make sure that the field you will use in your application as time picker control has a saved named range.
- Then open the Designer interface,
- Drag and drop a calendar control,
- Choose the named range added for the time picker control from the Named Range dropdown.
- Choose desired ‘time only’ options from the ‘DateTime Format’ dropdown.