+ Reply to Thread
Results 1 to 17 of 17

how do i insert a drop down calendar into excel 2010

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    how do i insert a drop down calendar into excel 2010

    hi there - can someone help! i need to put a drop down calendar into my current worksheet. is this poss!??!

    im running excel 2010

    many thanks

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: how do i insert a drop down calendar into excel 2010

    http://danielcurran.com/instructions...choose-a-date/

    Hi

    Have a look at the above link


    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    many thanks to ur quick reply........
    shame - my interenet protection policy denies access to personal sites which that is classified as - any chance of copying and pasting it to an email for me??!
    [email protected]

    thanks in advance

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    Here is one that I have used.

    http://fontstuff.com/vba/vbatut07.htm

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    yes i had just found that - its great!!

  6. #6
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: how do i insert a drop down calendar into excel 2010

    Hi

    Check your junk mail it sjould be in it waiting for you.

    Chris

  7. #7
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    cheers!
    onthe above link i was looking at - i have got to step 5 and found the Microsoft MonthView Control 6.0 isnt there??!? any explanation or how i can get it there!!?!?
    sorry! im kinda new to this!!

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    Is there a later version. Control 7 or 8.

  9. #9
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    no nothing - really strange!
    it has Microsoft ListView Control version 6 but not what i want!! grrrr!
    can i install it on here or?? is that not poss!!?

  10. #10
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    You should be able to download it here

    http://support.microsoft.com/kb/297381

    further explanation here
    http://www.excelbanter.com/showthread.php?t=241456

  11. #11
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    great thanks - do u know where i install it to???!

  12. #12
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    Because it is a cab file, I think it will self install if you double click on it after downloading. You can then delete the cab file.

    Install the MSCOMCT2.OCX file in the user's Microsoft Windows System or
    System32 directory. and then it should be available in the reference list..

  13. #13
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    it jsut pings up access denied when i try and save it in them files???!?!
    sorry - im being annoying now!! grr!

  14. #14
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    If you are working in a corporate environment, you may have to check with your IT people. They have probably denied you access to the system files on your machine. I am at the end of my knowledge base on this issue. Good Luck.

  15. #15
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: how do i insert a drop down calendar into excel 2010

    ok - many thanks for all ur help anyway!

  16. #16
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: how do i insert a drop down calendar into excel 2010

    Perhaps a new thread with this issue may give rise to some help that was not available before.

  17. #17
    Registered User
    Join Date
    08-03-2012
    Location
    Gurgaon
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cool Re: how do i insert a drop down calendar into excel 2010

    Using the mscomctl.ocx date picker control doesn't work always on all machines and all versions of excel.

    To avoid this problem you can create your own date picker on userform.

    To see how to create this - check this one

    XcelExtreme

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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