Page 1 of 2 12 LastLast
Results 1 to 10 of 11

XL 2010 Calendar control not available for userform

This is a discussion on XL 2010 Calendar control not available for userform within the Excel Questions forums, part of the Question Forums category; Hi guys - I've searched the forum and none of the links or replies help with regards to Excel 2010. ...

  1. #1
    Board Regular
    Join Date
    May 2008
    Location
    Sydney NSW Australia
    Posts
    263

    Default XL 2010 Calendar control not available for userform

    Hi guys - I've searched the forum and none of the links or replies help with regards to Excel 2010. I have the home version without any apparent Calendar control for 2010 in addditional controls. I understand I may have to install an add-in but all the forums I visited that mentioned this referred ot previous versions of Excel.

    Can anyone please help? As I said, a link to an explaination of a 2003 add-in without info on where to store or access it for 2010 probably won't advance me much as I've already checked some of these things out..

    Many thanks in advance for any help!

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,589

    Default Re: XL 2010 Calendar control not available for userform

    According to this:

    http://office-blog.net/post/Office-2...xcel-2010.aspx

    Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010. Instead, users can use Date Picker or their own custom calendar controls.

    Having said that version 11 seems to work for me in Excel 2010.
    Microsoft MVP - Excel

  3. #3
    Board Regular
    Join Date
    May 2008
    Location
    Sydney NSW Australia
    Posts
    263

    Default Re: XL 2010 Calendar control not available for userform

    Quote Originally Posted by Andrew Poulsom View Post
    According to this:

    http://office-blog.net/post/Office-2...xcel-2010.aspx

    Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010. Instead, users can use Date Picker or their own custom calendar controls.

    Having said that version 11 seems to work for me in Excel 2010.
    Thanks Andrew - I'm on 2010 home version and there is no Date picker option in additional controls. As I said I've read the posts about the options that are no longer available but I was hoping someone could point me to something I can use.

    I also tried downloading a custom built thing that didn't even seem to open so no joy there! Thanks anyway - I appreciate the effort.

  4. #4
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,555

    Default Re: XL 2010 Calendar control not available for userform

    The 2003 version from http://www.fontstuff.com/mailbag/qvba01.htm works for me with Excel 2010.
    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    Board Regular
    Join Date
    May 2008
    Location
    Sydney NSW Australia
    Posts
    263

    Default Re: XL 2010 Calendar control not available for userform

    Quote Originally Posted by VoG View Post
    The 2003 version from http://www.fontstuff.com/mailbag/qvba01.htm works for me with Excel 2010.
    Hi Peter

    I've tried this link - I copied the file to my system folder (but not sub folder) and used the run command as instructed, but my system said it wasn't compatible. Can I ask how you got it to work??

    Thanks again
    Will

  6. #6
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,555

    Default Re: XL 2010 Calendar control not available for userform

    Special instructions are needed for 64 bit versions of Windows. I have a link at home that I'll post later on today.
    HTH, Peter
    Please test any code on a copy of your workbook.

  7. #7
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,555

    Default Re: XL 2010 Calendar control not available for userform

    As promised http://social.answers.microsoft.com/...9-e757223ebdde

    See second reply by Jay Freedman.
    HTH, Peter
    Please test any code on a copy of your workbook.

  8. #8
    Board Regular
    Join Date
    May 2008
    Location
    Sydney NSW Australia
    Posts
    263

    Default Re: XL 2010 Calendar control not available for userform

    Thanks so much for taking the trouble I'll check out the link now. Cheers, mate!

  9. #9
    Board Regular
    Join Date
    May 2008
    Location
    Sydney NSW Australia
    Posts
    263

    Default Re: XL 2010 Calendar control not available for userform

    Hullo again guys - whatever I try my computer tells me this option is not available on my machine. I have a home version of Office 2010 running on 2007. I've downloaded four different versions - custom built etc and I can't get any to work even by following instructions to the letter, or adding add ins from the developer ribbon etc or whatever else. The instructions are therefore incomplete or not appropriate for my situation!

    If anyone does have step by step (without missing steps!) instructions that can help I'd be most grateful - if not, I am a quarter way building my own from scratch but it's pretty complex and I'm not confident I can get it to work properly - and my dates are limited. Not much to show for two days' work, but if it's functional I'll post it!

  10. #10
    Board Regular
    Join Date
    Apr 2011
    Posts
    69

    Default Re: XL 2010 Calendar control not available for userform

    Try without active x controls?

    http://bulevardi.be/?content=scripting&example=exvb9

    The script contains:
    - a 3 month overview
    - ability to select multiple dates and to add messages to them
    - features a tool to edit and delete messages
    - fully modifiable

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com