Alternative to MSCOMCTL.ocx

[vlc]

Hi everyone,

I'm moving my project from 2010 to 2013 (no other option) and all is working fine but the frmCal, my guess is cause the MonthView Control is missing. Is there anything that replaces it?

Please advise.

JC

[Excel Fox]

You should have the same control available in Excel 2013. However, the MSCOMCTL.ocx file version might be different, and hence would be throwing an automation error. One way would be to update your form with the latest control, OR (haven't tested that for 2013, but it did work when I had an issue with Excel 2007 service pack change), downgrade this particular ocx file in your computer by registering the older version of this file.

[jaslake]

Hi vlc

Don't have Excel 2013 and don't know what the MonthView Control is. I suspect it's the old Calendar Control from pre Excel 2007. If so this link may be of help
Non ActiveX Calendar Control (http://www.excelforum.com/excel-programming-vba-macros/822395-non-activex-calendar-control.html)

[Admin]

Hi

Another one: Calendar Control for All Office versions - including Office 2010 64 bit (https://sites.google.com/site/e90e50/calendar-control-class)

[MrBlackd]

I have been using a date picker that is able to work in both office 2007 and 2010 and I find it very handy.
In my home pc, Office 2010, english regional settings used everything is working great!

However I use this control in my work laptop that has Greek regional settings (in order to make other apps work) and office 2007.
The only problem is that the month name is not showing properly... see the pic below...

1002

If I click on the month name and the drop down list appears with all months then they all show up properly and they are readable.
I know that I could just change my windows regional settings but this is not an option since other apps installed from my company IT dept will stop working.
Is there any way to make the specific control show the months always in English like in the pic below?

1003

Sorry not to ask in a new thread but since there is a related thread already it seemed proper to post here!

Mr. Black'd

[Excel Fox]

Mr Blackd, can you post a sample workbook with this control?

[Excel Fox]

In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/office-version-independent-non-activex-date-time-picker-using-form-controls-1238/

[MrBlackd]

Mr Blackd, can you post a sample workbook with this control?

Here you go... 1004
Note that I have found this online as an alternative to an older date picker form that was working only in office 2007.
And it does a great job but ... well I described the issue above %p

but in order to clarify more I add these two screenshots of the file I attach

one with the form as seen with greek regional settings
1005

and one with the form as seen with english regional settings
1006


In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/office-version-independent-non-activex-date-time-picker-using-form-controls-1238/

I have already seen this form for the date here today but not in detail...

I will probably use it if I fail to find a solution to my issue. ;)


And thanks for your reply.