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

excel

Macros and VBA

JohnMills

Copper Contributor

Sep 30, 2020

MahboobQadri

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

LeifViking4020
Copper Contributor
Apr 05, 2023
JohnMills
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?