Forum Discussion

MahboobQadri's avatar
MahboobQadri
Copper Contributor
Mar 23, 2020

Adding Microsoft Date Picker to Excel VBA Userform

Hi Everyone, I'm trying to make a userform in Excel VBA. I need to add a date picker. But that isn't available in the list of available tools (Not in additional tools list). I saw a tutorial on Youtube for adding this tool. The method includes downloading and copying a file named "mscomct2.ocx" into windows directory "Syswow64" and registering it. I did that. But even after following the procedure there is not date picker in the list. Can anyone please help me with that? How do I add a date picker to my userform? Thanking in anticipation. 

 

11 Replies

  • ColinHWright's avatar
    ColinHWright
    Copper Contributor

    MahboobQadri

    I did a LOT of digging on this topic last night trying to find a workable solution and I came across the most AMAZING free add-in by way of Reddit. It's super sharp, very configurable with a plethora of arguments available, and it far exceeds my expectations! I wanted to share it in case anyone else might find it helpful. The instructions on the site gave me everything I needed to get up and running.

     

    https://trevoreyre.com/portfolio/excel-datepicker/

Resources