none
Excel 2013 Popup Calendar RRS feed

  • Question

  • There used to be a calendar control in older versions of Excel that would popup a calendar when a particular cell was selected. There now doesn't seem to be a calendar control in Excel 2013 or am I missing something somewhere?

    There isn't as official Microsoft solution?

    Thanks

    I tried the exposed on https://social.msdn.microsoft.com/Forums/office/en-US/36f83f24-cd76-4f8e-aa7b-5f166666e7d3/excel-2013-popup-calendar but it wont work on Excel 2013, cause the link is not avaliable for download or other tools are for excel 2010.


    Thursday, December 17, 2015 1:27 PM

Answers

  • Hi,

    >>There now doesn't seem to be a calendar control in Excel 2013 or am I missing something somewhere?<<

    As far as I test I can use the Microsoft Month View control in Excel via Developer->Controls->Insert->Active Controls->More Controls.

    And there is no MSCOMCT2.OCX installed on your computer, I suggest that you submit the feedback from bottom of the web link below to report the link broken issue.

    https://support.microsoft.com/en-us/kb/297381

    In addition, as a easy workaround we can also create a VSTO solution and use the calendar provide in .Net Framework.

    Here are helpful links for you get started:
    Create VSTO Add-ins for Office by using Visual StudioWalkthroughs Using Excel

    Calendar Class

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 18, 2015 8:45 AM
    Moderator