+ Reply to Thread
Results 1 to 20 of 20

Need Excel Date Picker Without VBA or any Add-ins

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Angry Need Excel Date Picker Without VBA or any Add-ins

    Dear ExcelGeeks,

    I want a datepicker in my excel sheet. When I click on a cell, a calendar should pop up and I should be able to pick a date from the calendar. I can't use macros, VBA or add-ins due to various reasons. Is there any way that I could get this? If possible, please show me with a sample attachment. I appreciate your help.

    Thanks,
    Nivi

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Need Excel Date Picker Without VBA or any Add-ins

    N, you may want to try data validation.

    In the attached, clicking into A1 allows you to pick a date. The list of dates need to be in a separate list.

    You can change the date list (or create one) by going to the menu 'Data'-->'Validation'.

    Cheers
    Attached Files Attached Files
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Hi..
    On the Developer Tab.. Click Insert .. then Click "More Controls" (bottom right side icon that looks like tools)... then select the "Microsoft Date and Time Picker.."..

    See how you go..

  4. #4
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Thanks for your reply. However, the data will go long and I cant let the users to scroll through a long list. I would be interested in a better UI. A calendar like this (http://www.fontstuff.com/excel/image...03_05.gif)???? Is that still possible?

  5. #5
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Thanks for your reply. However, the data will go long and I cant let the users to scroll through a long list. I would be interested in a better UI. A calendar like this (http://www.fontstuff.com/excel/image...03_05.gif)???? Is that still possible?

  6. #6
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Need Excel Date Picker Without VBA or any Add-ins

    There are a few Excel datepickers available..

    Example:
    http://www.excel-it.com/excel_datepickers.html

    But.. no VBA and no add-ins.. you are limited to the native controls i think..

  7. #7
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Here is instructions on how to do that

    http://www.fontstuff.com/excel/exltut03.htm
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  8. #8
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    @Apo: I've already seen this thread and this is an add-ins. I can't use this unfortunately.

  9. #9
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Need Excel Date Picker Without VBA or any Add-ins

    N - how about using three cells to pick the date?

    A1: picks from a list of numbers 1 through 31 using data validation
    B1: picks a month 1 through 12 using data validation
    C1: picks a year from a list using data validation or just key in the year (quicker than scrolling a long list)
    D1: =IFERROR(DATE(C1,B1,A1),"Not a proper date")

    If you pick 31-Feb-2013, then it shows "Not a proper date".

    Cheers

  10. #10
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Dear nivivani,

    Please understand that some things just don't materialize out of thin air.

  11. #11
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Question Re: Need Excel Date Picker Without VBA or any Add-ins

    @Alkey: I cannot see "Microsoft Date and Time Picker Control" in my excel sheet when I go there. See attached. If I can get this, I think my problem would be solved. Is there anything I am missing?
    @Amit: I thought of that. But, it will be more tedious. Rather, I will ask my users to type the date for that.
    Attached Files Attached Files
    Last edited by nivivani; 12-02-2013 at 09:48 AM. Reason: typo

  12. #12
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Refer to post #3 on how to add that..

  13. #13
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    @Apo: I've tried that. Please understand my problem. When I click on the Developer Tab, Click Insert and then Click "More Controls", I don't see anything like "Microsoft Date and Time Picker.." Please see the attached image Excel_Date_Picker.jpg to understand what I mean.

  14. #14
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Sorry for reviving, but this problem doesn't seem to be solved yet.

    I have the same problem, read about select: date picker or month thingy,... but there is just no such thing in my Excel.
    The picture in nivivani's last post is the same I have. Amit's solution ain't bad. But it's easier to click a date then to type in 3 values.
    So I have the same problem, except that I don't need to stick to formula's. VBA is allowed

  15. #15
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Then use the Calendar control called "The Calendar Form" that you can get from this page..
    http://www.excel-it.com/excel_datepickers.html

    I use it all the time.. its great.. very simple to integrate...

  16. #16
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Quote Originally Posted by apo View Post
    Then use the Calendar control called "The Calendar Form" that you can get from this page..
    http://www.excel-it.com/excel_datepickers.html

    I use it all the time.. its great.. very simple to integrate...
    thanks, I'll see if even I find it easy to integrate and use it the way I want


    --Edit--
    Yes it is that easy
    Last edited by Evolta; 12-05-2013 at 11:23 AM.

  17. #17
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    @Apo: Any idea on how to get the "Date Picker" in my "More Controls"? I've googled for that also and couldn't find help.

  18. #18
    Registered User
    Join Date
    09-18-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need Excel Date Picker Without VBA or any Add-ins

    And I will try the "Calendar Form" in between..

  19. #19
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Re: Need Excel Date Picker Without VBA or any Add-ins

    Quote Originally Posted by nivivani View Post
    And I will try the "Calendar Form" in between..
    This tool is almost the same, you can edit the code a bit to make it do whatever you want. The code is very transparent

  20. #20
    Registered User
    Join Date
    04-05-2016
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    1

    Re: Need Excel Date Picker Without VBA or any Add-ins

    wow that is amazing

+ 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. Excel 2010 - Date Picker
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-04-2013, 02:52 AM
  2. Set up Excel Form with Pop-up Date Picker
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2010, 01:47 PM
  3. Excel Date Picker
    By Wshadow in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-12-2008, 01:12 PM
  4. [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
  5. Date Picker for Mac Excel 2004
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2005, 03:20 PM

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