Forum Discussion
How to add pop-up calendar in spreadsheet cell
To add a pop-up calendar in Excel that appears when you click a cell, you’ll first need to enable the Developer tab (via File > Options > Customize Ribbon). Once enabled, go to Developer > Insert > More Controls, and look for "Microsoft Date and Time Picker Control". If available, you can insert it onto the sheet, then link it to a specific cell by setting its LinkedCell property. However, if you're using a 64-bit version of Excel or the control isn't listed, you'll need to use a VBA workaround. This involves creating a UserForm with a calendar control (like MonthView) in the VBA editor and using code to show it when a user clicks a specific cell. Let me know if you'd like help setting up the VBA version!
Depends on Excel. In Excel for web it's enough format cell as Date and double click on it, pop-up with date picker appears. Hope one day will be on desktop as well.
- Matt-Apps4RentMay 21, 2025Iron Contributor
Yes, I noticed that behavior in Excel for the web — the built-in date picker that appears when you double-click a cell formatted as Date is definitely a handy feature. I agree, it would be great to see the same functionality in the desktop version soon for consistency and ease of use.