Forum Discussion

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 Youtu...

Copper Contributor

Sep 30, 2020

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...

Copper Contributor

Apr 05, 2023

How to get it, add it and register it. I use excel 2016 and windows11.

Leif

Kimicko
Copper Contributor
May 03, 2023
LeifViking4020

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
- DhanasekaranT
  Copper Contributor
  Mar 19, 2024
  Kimicko what about office 365 (2024) windows 64bit?
- picklefactory
  Copper Contributor
  Sep 25, 2023
  Sorry to hijack, slightly, but would this also work with Office 2010?
  - Jack_Aid
    Copper Contributor
    Oct 17, 2023
    picklefactory
    In response to your question. Yes, Using these two OCX files, MSCOMCT2.OCX and MSCOMCTL.OCX. really works with Office 2010. I am currently using it now. However, it only works with 32-bit version of Office 2010 ---- but not the 64-bit version.

Resources