Results 1 to 3 of 3

Date & Time Picker Excel 2010

This is a discussion on Date & Time Picker Excel 2010 within the Excel Questions forums, part of the Question Forums category; Hello All. I'm using excel 2010. I came across a great time & date picker here; http://isamrad.com/ExcelCal/default.htm http://blogs.office.com/b/microsoft-...e-pickers.aspx It's aesthetically ...

  1. #1
    Board Regular John Caines's Avatar
    Join Date
    Aug 2006
    Location
    Poole
    Posts
    974

    Default Date & Time Picker Excel 2010

    Hello All.
    I'm using excel 2010.
    I came across a great time & date picker here;
    http://isamrad.com/ExcelCal/default.htm
    http://blogs.office.com/b/microsoft-...e-pickers.aspx

    It's aesthetically perfect,, only,,, it seems to be made for earlier versions of excel.
    I have emailed the developer to see if he is going to make it 100% 2010 compatible.

    If I protect my sheet & click in a cell where a small calender icon should appear to the right of the cell,, it doesn't
    A couple of other issues also unfortunately.

    So,, my question is,,,
    Is there a 100% compatible Date & time picker for excel 2010 that is comparable to this?

    I do see that excel offer formulas for dates/times etc.
    But I really am looking for something (KISS) ,, simple to use, to insert a use defined date,, (Which I can format the cell as day/date/mth/yr )
    The above also has a right click context menu option that says "Pick from Calender"

    It's so good,, if only it worked 100% in 2010

    Has anybody got any ideas/solutions or ran into similar problems?

    I hope somebody can advise on an alternative root.

    Many thanks for your time.
    John Caines

  2. #2
    Board Regular bensonsearch's Avatar
    Join Date
    May 2011
    Location
    NSW Australia
    Posts
    844

    Default Re: Date & Time Picker Excel 2010

    I havent really used 2010 that much, but doesnt it come with its own datetime picker control?

    if not the other option would be to make one yourself out of other controls, but that is prob more effort than worth

    does the date need to be "picked" from a calendar? are they within a range? or they can select any date they wish?
    Sometimes just writing down your idea and trying to get others to understand the logic makes you realise what you need to do (after all coding is nothing but logic)

    Need expert help? Try these helpful and promising people

  3. #3
    Board Regular
    Join Date
    Oct 2011
    Posts
    1,379

    Default Re: Date & Time Picker Excel 2010

    Bensonsearch is right.
    2010 does have it's own datepicker.

    This link will show how to insert it.

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

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