ActiveX control screwup needs correction (old version of date picker and month view .ocx)

kromano32

New Member
Joined
Jun 5, 2013
Messages
1
During the course of a VBA project for work I needed a date picker control of some kind. I failed to see one in my home PC (all Pcs involved are running Excel 2010) so I discovered the MonthView control online, which I also failed to notice in my "additional controls" list.

I now realize that both the date picker and the MonthView controls are available through the either MSCOMCTL.ocx or MSCOMCT2.ocx in either ...\windows\system32 or ...\windows\sysWOW64. These files are apparently for the Microsoft Windows common controls reference. However, before realizing this, i tried to install a downloaded "MSCOMCT2.ocx" file from a "Support" sub-folder within the folder containing my file (on my desktop).

PROBLEM:
My date-picker and monthview controls are failing because they are associated with a reference that no longer exists (the file that was on my desktop). Now, even when I load the CORRECT reference (C:\Windows\SysWOW64\MSCOMCTL.ocx), which should contain the date-picker and monthview controls, those controls STILL show up in the "Additional Controls" list as being supported by the file on the desktop, and therefore fail.

I need some way to "uninstall" those controls, and let the ones in from the correct reference become populated.

Thank you for any assistance...

-Keith (kromano32)
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top