How to create a named range for a time picker control

You are here:

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.
Tags: