- Close Excel Application
- Download MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
- Extract MSCOMCT2.cab Files | the .inf file and the .ocx file
- Install | right-click the .inf file | hit "Install"
- Move MSCOMCT2.ocx file | Move from :
"C:\Windows\system32" to "C:\Windows\sysWOW64"
- Run CMD | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator"
- Register Active-X File | Type :
regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx
- Open Excel | Open VB Editor
- Activate Control | Tools->References->Browse->Select mscomct2 from "C:\Windows\sysWOW64"
- Select "Microsoft Windows Common Controls 2-6.0 (SP6)"
- Go To Tools -> Additional Controls
- Select "Microsoft Monthview Control 6.0 (SP6)" (if applicable)
- Use 'DatePicker' control for VBA Userform
Option 1 | Check if "Calendar" ability already exists
Option 3 | if The "Additional Control" doesn't currently exist or disable