Create a named range for a time picker control
Workbook Preparation 1:28 video

How to create a named range for a time picker control

One focused task, a quick video, and concise steps you can scan immediately.

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.