Reading an article from the web it says to go to the Toolbox in the VBA editor, select Additional Control and pick the Calendar Control 10 (for Excel 2002). I'm using Excel 2013 and there is nothing similar in my Additional Control. Where / How can I add the Calendar control in my UserForm?
Welcome to my world.
I await the GURU's responses to this query.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
See, if you have checked Microsoft Windows Common Controls-2 6.0 in references.
If you don't have something like that at all you can try this link:
https://social.msdn.microsoft.com/Fo...popup-calendar
Sorry, doubled answer...
Thanks Sbarro79 for the help but did not work for me. I followed what the link says and installed the mscomct2.ocx /.inf to my system32 directory and back to Excel in the Tools / references I dont see anything similar to Microsoft MonthView Control 6 (SP6) or similar. The only items check in my references are:Visual Basic for Apps, MS Excel 15.0 Object Library, OLE Automation and MS Office 15.0 Object Library.
I wonder why MS left out such a common control and have to go thru all this hassle. Any further help will be appreciated
The calendar control isn't a standard control.
If posting code please use code tags, see here.
What this means Norie, should I do something else?
Doesn't it cone with access? Seem to recall that, but may well be wrong, usually am
Looking at the comments from the link in post#3, I'm not the only one who downloaded the MS mscomct2.ocx and then could not find the calendar control in the Tools / Reference window. I wonder then how I could get this control
Did you register this control in the system - something like this:
https://www.youtube.com/watch?v=CIRwDnVMEr0
although I'm not sure if this is the right way...
Kyle
I think it did come with Access in earlier versions of Office and that was kind of the problem.
If you were developing something for Excel and used the calendar control, then distributed it to other users who didn't have Access installed, which wasn't unusual, then you'd run into problems.
Hi oskar44
It's my understanding mscal.ocx (Calendar Control) does not exist in Excel 2010 - 13, however, see this link http://www.gmayor.com/downloads.htm
Look for MSCAL.ZIP. The instructions for registering, etc. are included. If you have a Calendar Control in your Workbook, you may need to recreate it.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
I believe Microsoft stopped including the control starting with Office 2010. To make matters worse, if you are running a 64 bit version of Office (64 bit Office, not 32 bit Office on 64 bit Windows), I believe there is no 64 bit Calendar Control available.
For that reason many users have moved to a VBA only Calendar type control. There are many available. The one that I use can be found in the file associated with post #2 in the following thread: http://www.excelforum.com/excel-gene...-combobox.html
The above control can be used in a UserForm or can be associated with a spreadsheet cell. Examples of both usages are included in the file.
Lewis
Last edited by LJMetzger; 06-06-2015 at 03:47 PM.
Hi oskar44
If you're distributing the Workbook I'd strongly recommend a non-active X Calendar Control. There are many examples on this Forum...need help with that let me know.
PS: This is what Lewis is suggesting...I always go this route in developing...
I'm not distributing my workbook jastake, I'm retired and this is a hobby project to get involved with Excel a bit further. if you know a good link please let me know and in the mean time I'm checking the link you provided in your previous post. Thanks
Hi oskar44
I too am retired...this is a hobby of sorts for me. I've developed several personal applications that included Calendar Control. To my surprise (and satisfaction), my Children wished for me to share these applications with them. So, I had to rewrite the Code to include non Active X Calendar Control.
Here are links to several of my Posts on this Forum that relate to this subject. It depends where your Calendar is located...on a Worksheet or in a User Form. Again, need help, holler.
http://www.excelforum.com/excel-prog...-workbook.html
http://www.excelforum.com/excel-prog...s-visible.html
http://www.excelforum.com/excel-prog...userforms.html
http://www.excelforum.com/excel-prog...r-control.html
http://www.excelforum.com/excel-prog...-calendar.html
http://www.excelforum.com/excel-prog...in-2010-a.html
I have several others but these may get you on track...let me know how I can help.
Much appreciated John, I got working the link you provided on your previous post, got the mscal.ocx control registered and now looking to find it in my Excel References. I will look in your links above to see if I can find anything more useful to me. Thank you all for the help and I will be back if more help is needed
You're welcome...glad I could help. Thanks for the Rep.
The link your provided did not explain properly how to register the control "mscomct2.ocx" Now that I learned from the other link by Jastake in post 12, I register that control properly and it makes a nice ActiveX calendar in sheet1. Thanks for your time Sbaro79Originally Posted by Sbarro79
The attached image indicates what I try to achieve and before I go any further I would like to have some help regarding how I should proceed.
The 3 calendars on the left help navigating the days and although only one will be sufficient they are there to provide some symmetry to the form.
The date navigation control at the top is a more convenient way to go to a particular day and the Tab controls at the bottom left provide access to 2 additional forms (one for a phone list and one which will show all item separated by categories
My first question is if I should use Excel (2013) or Access (2010) to accomplish what I want. My knowledge in both is equal, that’s average!
Second question is should I use one form for all or different forms (sub forms) for each item?
What is unknown at the moment for me is how to achieve the entries for the dates and items (the 2 large rectangles in the attached image). Basically these rectangles are like an Excel sheet with rows to enter the date in one and the items description in the other. When you enter an item description, the row should expand to accept the length of the description which could be 1 line or 50 and when you finish and hit Enter the row should show all the text (like when you size a row in Excel to have all the text on it visible.
Any help is appreciated
Hi oskar44
Since this Thread is marked as SOLVED it won't get much play from those that can help you. Additionally, the Thread Title is not descriptive of your new requirements.
I'd suggest you start a new Thread for these new requirements.
If you MUST post images rather that uploading your File, please post jpg images...many of us cannot view png images.
Thanks John, I will just do this
Did you guys find that the Userform posted by LJMetzger Post number #13
does not really work?
I've spent some time on it and it seems to work to my satisfaction.
I have inserted three ways to output the date,
Delete the ones that are not appropriate for you.
I have created two public varaiables
MyDate is an Array MyDate(0) = Day, MyDate(1) = Month, MyDate(2) = Year
ThisDate is a Date
So you can call the Userform as a Subroutine and the date will be returned in both those variables.
There is a Line in the Normal macro routine that writes the date into B1:
Please Login or Register to view this content.
I have also added a line into the Userform code that writes the Date Array into A1:A3 as you change the date in the userform.
Please Login or Register to view this content.
Obviously this is still work in progress as I try to minimise the code.
Last edited by mehmetcik; 06-08-2015 at 02:22 PM.
The UserForm in my post #20 is not functioning because it's only a template of what I would like to achieve. I also followed Jastake recommendation (post #21) and I posted a new thread yesterday on this forum. When you have some time perhaps you can answer my questions in my new thread
Thank you for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks