Hello,
I have Windows 8, 64bit and Office 2010
I am trying to get the 'datepicker' (MonthView) ActiveX control toolbox in Excel 2010 as part of a Excel UserForm I have created. I have spent all day trying to find a solution for my problem.
I opened up the 'more.. ' but the MonthView/datepicker/calendar control is not listed.
I referred to some articles and confirmed that I do indeed have the mscomct2.ocx file in the C:\Windows\syswow64 folder.
I followed the instructions as above, opening up the Administrator Command Prompt and changed the directory to C:\Windows\syswow64 and typed in RegSvr32.
I received a popup screen confirming my registration was successful
Excel was closed. So I opened Excel and checked out the ActiveX Tool box and clicked on the 'More Controls', but there was no listing for the Microsoft MonthView control, (nor datepicker/calendar) .
I then downloaded the latest Windows Common Controls 2 6.0 from the following site http://support.microsoft.com/kb/297381
Copied the original file (2008) and saved it elsewhere on the computer for safekeeping.
Extracted the new mscomct2.ocx.
Under the C:\Windows\syswow64 I changed the original file properties to allow me to overwrite it with the new file. This worked old file replaced.
I then registered the new file via the Administrator Command Prompt (as above) and was notified that it was successful. I rebooted pc and went back into Excel to find the MonthView in the ActiveX toolbox, More Controls and it still wasnt there
I would be very grateful if someone could advise how I can get this control and allow me to use it.
If I have left out any information that you need to resolve this issue, please advise.
Cheers,
TheShyButter