- Microsoft Monthview Control 6 0 Excel 2013 Missing Numbers
- Microsoft Monthview Control 6 0 Excel 2013 Missing Key
I'm using Microsoft Excel 365
I cant find the [Microsoft MonthView control 6.0 (SP4)] tool in More Controls list.
I tried the following steps:
>>Download the MSCOMCT2.OCX
>> copy MSCOMCT2.OCX file and paste it in C:WindowsSystem32.
>> open Excel.
>> Go to “Developer” Tab. Click on “Insert” in “Controls” group.
>> Click on “More Controls”
>> then click on “Register Custom” Button.
>> then in C:WindowsSystem32 find the “MSCOMCT2.cab” and click on “ok” button.
But got a message: Cannot register this control.
Microsoft Monthview Control 6 0 Excel 2013 Missing Numbers
Microsoft Monthview Control 6 0 Excel 2013 Missing Key
One of our clients has several VBA macros in excel 2013 with the date picker control in VBA. All are working fine in 2008R2. He copied the same VBA and tried in 2012R2 /excel 2013. Date picker control was not available. I did some research and learned that Microsoft packed the control as.ocx which we need to download/copy and register it. ‘Microsoft Date and Time Picker Control 6.0 (SP6)’ is not available for the 64-bit version of MS Excel. After writing the VBA code, we need to save the file with ‘.xlsm’ (Excel Macro-Enabled Workbook) extension; otherwise, the VBA code would not run. Recommended Articles. This has been a guide to an excel date picker.