Forum Discussion

Antonio J Fabian

Copper Contributor

May 30, 2019

How to insert a Calendar in Excel 2013

Hi Everyone I wanna insert a drop-down calendar in my excel workbook Can someone help me I have Win 10 Excel 2013

Macros and VBA

Haytham Amairah

Silver Contributor

May 30, 2019

Antonio J Fabian

Hi,

Please check out this https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/

Hope that helps

sdinva7

Copper Contributor

Jul 08, 2019

Haytham AmairahThank you for your reply to another user. However, I don't have that listed. I go to Developer / Insert / Active X controls / more controls / and all I have is under the many Microsoft is Coolbar Controls going directly to DataGrid Control... Any suggestions? Lots of Microsoft items listed but none that look appropriate. (Microsoft 365 ProPlus)

Haytham Amairah wrote:
Antonio J Fabian

Hi,

Please check out this https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/

Hope that helps

Haytham Amairah
Silver Contributor
Jul 08, 2019
sdinva7

Hi,

If you scroll down the webpage I mentioned in the previous link, you will find this note:

The built-in DateTime picker in Excel only exists in the 32bit version of Excel.
If you have the 64bit version of Excel, you may try some third-party tools mentioned on the same page.

The good news is that the Excel team is currently working to add DateTime picker officially in all versions of Excel by this https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

Regards,
Haytham
- sdinva7
  Copper Contributor
  Jul 08, 2019
  Haytham AmairahApologize for not reading the full article. Thank you for your reply