How to create a named range for a calendar control
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.