StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>OFFICE 2013 INSTRUCTIONS</strong>:</p> <p>(For <strong>Windows 7 (x64)</strong> | MS Office <strong>32-Bit</strong>)</p> <p>Option 1 | Check if ability already exists | 2 minutes</p> <ol> <li>Open VB Editor</li> <li>Tools -> Additional Controls</li> <li>Select "Microsoft Monthview Control 6.0 (SP6)" (if applicable)</li> <li>Use 'DatePicker' control for VBA Userform</li> </ol> <p>Option 2 | The "Monthview" Control doesn't currently exist | 5 minutes</p> <ol> <li><strong>Close</strong> Excel</li> <li><strong>Download</strong> <a href="http://support.microsoft.com/kb/297381">MSCOMCT2.cab</a> (it's a cabinet file which extracts into two useful files)</li> <li><strong>Extract</strong> Both Files | the .inf file and the .ocx file</li> <li><strong>Install</strong> | right-click the .inf file | hit "Install"</li> <li><strong>Move</strong> .ocx file | Move from "C:\Windows\system32" to "C:\Windows\sysWOW64"</li> <li>Run <strong>CMD</strong> | Start Menu -> Search -> "CMD.exe" | right-click the icon | Select "Run as administrator"</li> <li><strong>Register</strong> Active-X File | Type "regsvr32 c:\windows\sysWOW64\MSCOMCT2.ocx"</li> <li><strong>Open</strong> Excel | Open VB Editor</li> <li><strong>Activate</strong> Control | Tools->References | Select "Microsoft Windows Common Controls 2-6.0 (SP6)"</li> <li><strong>Userform</strong> Controls | Select any userform in VB project | Tools->Additional Controls</li> <li><strong>Select</strong> "Microsoft Monthview Control 6.0 (SP6)"</li> <li><strong>Use</strong> 'DatePicker' control for VBA UserForm</li> </ol> <p>Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (x64). Some of the steps may be different if you have a different combo of Windows 7 & Office 2013. </p> <p>The "Monthview" control will be your fully fleshed out 'DatePicker'. It comes equipped with its own properties and image. It works very well. Good luck. </p> <p>Site: "bonCodigo" from above (this is an updated extension of his work) <br> Site: "AMM" from above (this is just an exension of his addition) <br> Site: Various Microsoft Support webpages</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload