How to create a named range for a calendar control

You are here:

To create a named range for a calendar control;

  • Open your Excel workbook,
  • Make sure that the date field has a saved named range.
  • Then open the Designer interface,
  • Drag and drop a calendar control,
  • Choose the named range added for the date field from the Named Range dropdown.
Tags: