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!
- SergeiBaklanMay 21, 2025Diamond Contributor
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.