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.
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.
- I would suggest to use an alternative solution as offered here: https://sites.google.com/site/e90e50/calendar-control-class
Hi, Just right click on Controls Toolbox -> Select Additional Controls -> Select "Microsoft Date and Time Picker Control.
- That control is not available on all systems and was deprecated I think with Office 2013
- Thanks
You need to register the following TWO DLL's: MSCOMCT2.OCX & MSCOMCTL.OCX
Been using this date picker for years, and very happy with it...
Hi Leif
You can use DatePicker, ListView, etc with Office 2016 32 Bits (x86).
Download this two OCX files, MSCOMCT2.OCX and MSCOMCTL.OCX. To get them, search from internet, it's easy to get to them.
Copy the two files to C:\Windows\SysWOW64
To register them, use System Command as Administrator (Windows Key + R, type cmd and then press CTRL + MAYUSC, then Enter key)
Copy and paste the following:
regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX"
regsvr32 "C:\Windows\SysWOW64\MSCOMCT2.OCX"
Then, you can now choose these two from VBA and use them.
Hope it helps!
Regards
