

It comes equipped with its own properties and image. The "Monthview" control will be your fully fleshed out 'DatePicker'. Some of the steps may be different if you have a different combo of Windows 7 & Office 2013. Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (圆4). Use 'DatePicker' control for VBA UserForm

Select "Microsoft Monthview Control 6.0 (SP6)" The 'Monthview' control will be your fully fleshed out. Userform Controls | Select any userform in VB project | Tools->Additional Controls Select 'Microsoft Monthview Control 6.0 (SP6)' Use 'DatePicker' control for VBA UserForm Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (圆4). For more information, see Create a template for a control. You can modify the default ControlTemplate to give the control a unique appearance. Register Active-X File | Type "regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx"Īctivate Control | Tools->References | Select "Microsoft Windows Common Controls 2-6.0 (SP6)" This topic describes the styles and templates for the Calendar control. Run CMD | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator" Select Tools/Additional Controls & check Microsoft MonthView Control 6. ocx file | Move from "C:\Windows\system32" to "C:\Windows\sysWOW64" Option 2 | The "Monthview" Control doesn't currently exist | 5 minutesĭownload MSCOMCT2.cab (it's a cabinet file which extracts into two useful files)Įxtract Both Files | the. Use 'DatePicker' control for VBA Userform Select "Microsoft Monthview Control 6.0 (SP6)" (if applicable) Option 1 | Check if ability already exists | 2 minutes
