Share via

Date picker not there

Anonymous
2022-12-20T06:03:47+00:00

Developer - More control - date picker is not there? how to show it?? or there is another way?

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2022-12-20T06:59:03+00:00
    1. The first thing I need to explain to you is that you can register the calendar control in a 64-bit system, but it only works with 32-bit office. Even if you add the reference to mscomct2.ocx/mscal. When ocx is in Excel 64-bit, it still returns the "Cannot load object because it is not available on this machine" error.
    2. Below are the steps I give you to install Microsoft Date and Time Picker Control 6.0 (SP6):

    Click the Windows Start button, type mscomct2.ocx or mscal.ocx in the search box, and hit Enter.

    1. If the file of mscomct2.ocx can be found

    • Right-click the Start button, Windows Terminal (Admin) -> then enter the following command:

    For Windows 32 bit:

    C:\Windows\System32\regsvr32.exe mscomct2.ocx
    

    For Windows 64 bit:

     C:\Windows\SysWoW64\regsvr32.exe mscomct2.ocx
    

    • Then click Enter, the file mscomct2.ocx will be successfully registered on your computer.

    • Once mscomct2.ocx is registered, restart Excel, go to the "Developer" tab, click "Insert" -> "More Controls", the Microsoft Date and Time Picker control will appear.

    Hope it helps.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-12-20T06:48:34+00:00

    Thanks a lot, but I'm looking for something we used to worked on.

    Is there any chance I can get the option below back?

    Thanks in advance

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2022-12-20T06:37:07+00:00

    Hi Ali Hayder90,

    Greetings! Thank you for posting to Microsoft Community.

    We did test on our side and this control is not in list. You may need to achieve it via third party controls.

    As a workaround, we found an Office add-in called Mini Calendar and Date Picker via add-ins, please try to check if it could meet your need:

    You can also Send feedback to Microsoft. Our related team will work on this feature.

    Thank you for understanding this.

    Best Regards,

    Snow Lu

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments