Close Excel
2.Download MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
3.Extract Both Files | the .inf file and the .ocx file
4.Install | right-click the .inf file | hit "Install"
5.Move .ocx file | Move from "C:\Windows\system32" to "C:\Windows\sysWOW64"
6.Run CMD | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator"
7.Register Active-X File | Type "regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx"
8.Open Excel | Open VB Editor
9.Activate Control | Tools->References | Select "Microsoft Windows Common Controls 2-6.0 (SP6)"
10.Userform Controls | Select any userform in VB project | Tools->Additional Controls
11.Select "Microsoft Monthview Control 6.0 (SP6)"
12.Use 'DatePicker' control for VBA UserForm
Bookmarks