+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 24

ToolBox No Calendar Control?

  1. #1
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    194

    ToolBox No Calendar Control?

    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?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,004

    Re: ToolBox No Calendar Control?

    Welcome to my world.

    I await the GURU's responses to this query.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: ToolBox No Calendar Control?

    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

  4. #4
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: ToolBox No Calendar Control?

    Sorry, doubled answer...

  5. #5
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    194

    Re: ToolBox No Calendar Control?

    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

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,551

    Re: ToolBox No Calendar Control?

    The calendar control isn't a standard control.
    If posting code please use code tags, see here.

  7. #7
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    194

    Re: ToolBox No Calendar Control?

    What this means Norie, should I do something else?

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,625

    Re: ToolBox No Calendar Control?

    Doesn't it cone with access? Seem to recall that, but may well be wrong, usually am

  9. #9
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    194

    Re: ToolBox No Calendar Control?

    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

  10. #10
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: ToolBox No Calendar 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...

  11. #11
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,551

    Re: ToolBox No Calendar Control?

    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.

  12. #12
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,584

    Re: ToolBox No Calendar Control?

    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.

  13. #13
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    3,460

    Re: ToolBox No Calendar Control?

    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.

  14. #14
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,584

    Re: ToolBox No Calendar Control?

    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...

  15. #15
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    194

    Re: ToolBox No Calendar Control?

    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

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1