Workbook Preparation 1:18 video

How to create a named range for a calendar control

Create the Excel named range required by a SpreadsheetWeb Calendar control so the application can read and write the selected date value.

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.