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 Youtu...
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
Kimicko what about office 365 (2024) windows 64bit?