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
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
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
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...
Capture.PNG
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?
Capture2.PNG
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
Mr Blackd, can you post a sample workbook with this control?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
In addition, did you try the custom calendar control I've posted at http://www.excelfox.com/forum/f13/of...controls-1238/
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Here you go... Book2.xlsmOriginally Posted by Excel Fox
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
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
RS GR.jpg
and one with the form as seen with english regional settings
RS EN.jpg
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.
Last edited by MrBlackd; 07-19-2013 at 10:50 PM.
Posting Permissions
Reply With Quote
Bookmarks