{"id":45,"date":"2019-08-25T18:20:43","date_gmt":"2019-08-25T18:20:43","guid":{"rendered":"http:\/\/pragmaticways.com\/?p=45"},"modified":"2021-01-26T13:06:25","modified_gmt":"2021-01-26T13:06:25","slug":"how-to-add-a-datepicker-calendar-to-excel-cells","status":"publish","type":"post","link":"https:\/\/pragmaticways.com\/how-to-add-a-datepicker-calendar-to-excel-cells\/","title":{"rendered":"How to add a DatePicker (Calendar) to Excel Cells"},"content":{"rendered":"\n
\"\"<\/figure>
\n

Do you need a DatePicker Calendar in your Excel spreadsheets? Follow this quick and simple tutorial to find out how. (If you prefer video, scroll down to the bottom of the page!) <\/p>\n<\/div><\/div>\n\n\n\n

Step 1. Enable Developer Mode in Excel<\/h2>\n\n\n\n
  • File<\/li>
  • Options<\/li>
  • Customize Ribbon<\/li>
  • Ensure Developer checkbox is enabled<\/li><\/ul>\n\n\n\n
    \"Enable<\/figure>\n\n\n

    [sibwp_form id=100]<\/p>\n\n\n\n

    Step 2. Setup DateTime Control box<\/h2>\n\n\n\n
    • Microsoft Date and Time Picker Control<\/li>
    • Click on random cell to place control box<\/li>
    • Edit or remember the name box of the DateTime Picker, in this case, we will leave it as DatePicker1<\/li><\/ul>\n\n\n\n
      \"Name<\/figure>\n\n\n\n
      • Right click on DateTime Control box<\/li>
      • DTPicker Object<\/li>
      • Properties<\/li><\/ul>\n\n\n\n
        <\/div>