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,

Hi,

The pictures which you uploaded failed three, would you like to upload again? Which Office 2010 version did you use? 64-bit or 32-bit?

As far as I know, ActiveX controls library, could not be used in Office 64-bit version.

http://office.microsoft.com/en-us/support/choose-the-32-bit-or-64-bit-version-of-office-HA102840825.aspx

If you use Office 2010 32-bit, please try to do the following steps:

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files. 
* Type the following and then press Enter:  regsvr32 \Windows\SysWOW64\ mscomct2.ocx
* You should get a message saying this succeeded.

For more detail information, please refer to the following link:

http://code.msdn.microsoft.com/windowsdesktop/How-to-use-MonthView-5e8b32be

Regards,

George Zhao
TechNet Community Support

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, December 05, 2013 6:45 AM

Hi,

The pictures which you uploaded failed three, would you like to upload again? Which Office 2010 version did you use? 64-bit or 32-bit?

As far as I know, ActiveX controls library, could not be used in Office 64-bit version.

http://office.microsoft.com/en-us/support/choose-the-32-bit-or-64-bit-version-of-office-HA102840825.aspx

If you use Office 2010 32-bit, please try to do the following steps:

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files. 
* Type the following and then press Enter:  regsvr32 \Windows\SysWOW64\ mscomct2.ocx
* You should get a message saying this succeeded.

For more detail information, please refer to the following link:

http://code.msdn.microsoft.com/windowsdesktop/How-to-use-MonthView-5e8b32be

Regards,

George Zhao
TechNet Community Support

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, December 05, 2013 6:45 AM

Hi George,

Thank you for checking this out ... :)

I am using Office 2010 64 bit ...

I found the mscomct2.ocx file originally within the C:\Windows\syswow64 directory (this was an original file .... which I expect was installed via Microsoft at the time of the Office installation.

As I mentioned above, I followed the instructions (same as the ones you suggested), but still no go, even though it stated that the registration was successful ! :(

Why weren't these features included in the 64 bit ? ... yes, I read the article ... but ... so MS doesn't think that people/developers would be needing this in due course?  I installed the 64bit version because I'm running the Win8 64bit version ...and I deal with a lot of large spreadsheets and can't afford to sleep whilst they decide to load.

If MS included all the other ActiveX controls and some obscure ones, surely some bright spark could have thought that something as useful as MonthView should be included as 'basic' necessity when dealing with forms and sheets?

Perhaps you could pass the suggestion up the line .... there are a lot of other people out there having the same problem ... I found heaps when I was looking for a solution.

Sorry, I'm not having a go at you, but just incredibly frustrated .... the amount of lost productivity directly cause by trying to find a solution that doesn't exist ... it's been at least a good solid 24 hours.

But thank you for taking the time to review my post and your suggestion. It's unfortunate that because you are part of the organisation ... you tend to cop some slack from frustrated people like myself.

In relation to the pictures/screen dumps, 2 of them made it (I can see them in my post) ... one I deliberately left out because there was nothing on there that showed anything other than the rest of the 'More Controls' - nothing to do with the MonthView.

Please feel free to escalate this to the powers that be ... and hopefully enough people will join the voice so a change can be made (I can dream ... can't I?)

I've taken a screen dump of the Forms/ActiveX toolbox.

I don't know what the next step is ... I guess you'd be able to advise.

Cheers,

TheShyButterfly

Looks like its too difficult to answer :( .. and it's their own product :(

I'm sure there are many others who are faced with the same thing - why wasn't included in Excel 2010? ... just curious :)

I have the same problem. I followed all the same steps (although given to me thru another link) and like you mine didn't work either. 

No idea why, and no one can tell me. Might try Mr Excel or Chandoo and see if anyone there can help. 

IM HAVING THIS EXACT PROBLEM!!!!

Except I have spent 3 days on this! Im going crazy! Honestly, who was the basic human being (or group of) who decided this was a good idea! You are actually sending humanity BACKWARDS. I cant believe this, all this was meant to be was a simple interactive spreadsheet with a calendar option. Thats all I need, thats all my boss asked me for and now I look like an absolute idiot because this just will not work! Not happy Microsoft! Get your **** together!  

I ran across the same issue today; however, I found a solution.

Through some research, I found a standalone Excel Date calendar that someone created and was willing to share.

I wanted to post a link but I couldn't since I just registered on this, but try the MrExcel website. Search on "Excel 2010 Missing Calendar Control workaround". Look for response by "nocky". He created a Excel Date calendar form that you can easily utilized.

No setup needed on any user's PC. Just add the necessary code from the downloaded Excel spreadsheet (he provides) to your own and make some minor code adjustments and viola your problem is solved. Hope this helps.