+ Reply to Thread
Results 1 to 15 of 15

Macro for Date Picker in excel 2013

Hybrid View

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Macro for Date Picker in excel 2013

    Dear Experts,

    Please find here attached worksheet, Dear Experts i am looking in my worksheet 90Days Rolling CashFlow in Cell D4 as Date Picker. Can you please help me out on my thread.

    thank you for your precious help and support.

    Regards,

    Neilesh
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Macro for Date Picker in excel 2013

    validation list fo 90 days
    Attached Files Attached Files

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    validation list fo 90 days
    Dear Expert,

    Thank you so much for your precious efforts. But i am looking for the Date Picker Calendar instead of drop down so i can pick any month any year and any date. In excel 2013 Microsoft Month View Control is unavailable and resulting the same i am looking for the macros.

    Request to you please do help me out.

    Regards,

    Neilesh

  4. #4
    Forum Contributor
    Join Date
    12-14-2016
    Location
    UAE
    MS-Off Ver
    MS OFFICE LTSC 2024
    Posts
    158

    Re: Macro for Date Picker in excel 2013

    see if this is ok
    Attached Files Attached Files

  5. #5
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by sathishsusa View Post
    see if this is ok
    Dear Sir,

    In excel 2013 Microsoft Office Month View Control is unavailable and resulting the same my calendar user form could not be loaded. If you please do provide any substitute for the same would be highly appreciated.

    Regards,

    Neilesh

  6. #6
    Forum Contributor
    Join Date
    12-14-2016
    Location
    UAE
    MS-Off Ver
    MS OFFICE LTSC 2024
    Posts
    158
    Quote Originally Posted by Neilesh Kumar View Post
    Dear Sir,

    In excel 2013 Microsoft Office Month View Control is unavailable and resulting the same my calendar user form could not be loaded. If you please do provide any substitute for the same would be highly appreciated.

    Regards,

    Neilesh
    https://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/date-picker-dropdown-in-excel-2013/71decdcd-6cc6-4a70-b1ab-20294a2a315a

    follow this link to install date picker for 2013

  7. #7
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Macro for Date Picker in excel 2013

    Do something radical - search your thread title in Google.

  8. #8
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Macro for Date Picker in excel 2013

    on any sheet in this workbook just doubleclick
    Attached Files Attached Files
    Last edited by tim201110; 05-03-2017 at 02:59 PM. Reason: new file

  9. #9
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    on any sheet in this workbook just doubleclick
    Dear Expert,

    Thank you so much for your precious efforts, its really fabulous. Only i modification required here that is the months names are not in english. So, can you please do provide the months name in english.

    thank you once again.

    Regards,

    Neilesh

  10. #10
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    on any sheet in this workbook just doubleclick
    Dear Expert,

    While selecting the date, Calendar is not giving the correct output. Request to you kindly do help on the same.

    Regards,

    Neilesh

  11. #11
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    on any sheet in this workbook just doubleclick
    Thank you so much Dear Expert for your valuable and precious support. Thanks a lot once again.

    Regards,

    Neilesh

  12. #12
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Macro for Date Picker in excel 2013

    changed file

  13. #13
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    changed file
    Dear Expert,

    Attachment is missing here. Can you please provide the changed file.

    Thank you for your precious support.

    Regards,

    Neilesh

  14. #14
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Re: Macro for Date Picker in excel 2013

    Quote Originally Posted by tim201110 View Post
    changed file
    Dear Expert,

    Thank you so much for your precious efforts. I got the file. Once again thank you so much.

    Regards,

    Neilesh

  15. #15
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Macro for Date Picker in excel 2013

    You are wellcome.
    But the project doesn't work as intended.
    Not all months have 31 day. If one chooses such a month, unexisting days (labels) must be inactive, but they are not. And the first of a month must be right under its weekday, it is not.
    edit
    attached working version
    Attached Files Attached Files
    Last edited by tim201110; 05-04-2017 at 09:34 AM. Reason: fixed errors

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 03-08-2017, 11:00 PM
  2. Need Excel Date Picker Without VBA or any Add-ins
    By nivivani in forum Excel General
    Replies: 19
    Last Post: 04-05-2016, 08:43 PM
  3. Replies: 3
    Last Post: 07-20-2014, 11:46 AM
  4. DT Picker in excel 2013
    By mdshotgun in forum Excel General
    Replies: 0
    Last Post: 12-15-2012, 06:08 PM
  5. Date Picker in Excel 2007
    By RJMooreII in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2010, 02:09 PM
  6. Excel Date Picker
    By Wshadow in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-12-2008, 01:12 PM
  7. [SOLVED] Is there a way to get a Date Picker Box in Excel?
    By Andrew Holzman in forum Excel General
    Replies: 1
    Last Post: 01-24-2006, 05:50 PM

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