Forum Discussion
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
- ColinHWrightCopper Contributor
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/