+ Reply to Thread
Results 1 to 4 of 4

How to insert a drop down calender

  1. #1
    Registered User
    Join Date
    06-20-2021
    Location
    Male',Maldives
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    6

    How to insert a drop down calender

    As the title says, I want to know how to insert a drop down calendar in excel sheets. I did some browsing and found that I need to have Microsoft Date and Time Picker Control downloaded for that. I am using Office 2019 but I couldn't find that control under ActiveX controls (according to google searches, Office 2016 and above should have it). So how do I get or find it? Any working link or trick will be appreciated.

    Thank You!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,384

    Re: How to insert a drop down calender

    Is this any help.

    It's a date picker I designed for a client a while back. There's a Date Picker userform in with the attached file as well as the module and sheet code mentioned below.

    It responds to a Sheet SelectionChange event where there is a cell named "startdate". Change that If Not Intersect...code to include a whole column of dates if you wish.

    See attached file where D1 is the startdate



    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Richard Buttrey; 06-21-2021 at 09:42 AM.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,161

    Re: How to insert a drop down calender

    Over the years datepickers have been the cause of much frustration.
    In the link below is the approach I take if at all possible (i.e. if people listen and do not insist on having pretty gizmos, with bells and whistles).
    Far quicker to use a simple textbox (enter the date as eight digit number or time as four digit number(24 hour clock) textbox formatted to put separators in automatically
    However if you want a datepicker and cannot install MS default, try one of the attached files - double click in cell - in the case of the one with a table on the sheet, it follows the active cell, it will only allow you to enter a date when there is data in the adjoining cell of the table - with the one with a timepicker click on the hour or mins window, it will highlight, you can then use the spinner to adjust, selecting the date then places the combined date & time in the cell.
    torachan.

  4. #4
    Registered User
    Join Date
    06-20-2021
    Location
    Male',Maldives
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    6

    Re: How to insert a drop down calender

    Thank You for the responses! I finally got one working.

+ 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. Help with calender and drop down lists
    By AKJRADIO in forum Excel General
    Replies: 8
    Last Post: 06-02-2020, 04:33 AM
  2. Drop Down Calender
    By redza in forum Excel General
    Replies: 3
    Last Post: 07-23-2013, 05:02 AM
  3. drop down calender in excel
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2013, 12:52 AM
  4. excel 2010 Calender drop down
    By gal4.7 in forum Excel General
    Replies: 0
    Last Post: 08-23-2011, 08:54 AM
  5. Insert calender into a cell
    By Deepa7476 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2006, 01:55 AM
  6. Insert calender into a cell
    By Deepa7476 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2006, 08:45 AM
  7. Exel Calender drop down box 2005
    By Allen in forum Excel General
    Replies: 1
    Last Post: 01-23-2005, 12:06 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