"MonthView"
Calendar on MS Office 2013

Option 2 | The "Monthview" Control doesn't currently exist

  1. Close Excel Application
  2. Download MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)
  3. Extract MSCOMCT2.cab Files | the .inf file and the .ocx file
  4. Install | right-click the .inf file | hit "Install"
  5. Move MSCOMCT2.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->Browse->Select mscomct2 from "C:\Windows\sysWOW64"


  10. Select "Microsoft Windows Common Controls 2-6.0 (SP6)"


  11. Go To Tools -> Additional Controls


  12. Select "Microsoft Monthview Control 6.0 (SP6)" (if applicable)
  13. 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