+ Reply to Thread
Results 1 to 4 of 4

Inserting drop down calendar in excel 2019

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    Castlebar, Ireland
    MS-Off Ver
    windows 10/Excel 2019
    Posts
    79

    Inserting drop down calendar in excel 2019

    I am building a company monthly time sheet using EXCEL 2019 and have a date box. Currently users have to input the date manually. I would love to add a drop down calendar to make it easier but I do not have the option in the Developer Tab to add the date/calendar. Any help would be much appreciated

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Inserting drop down calendar in excel 2019

    Follow the instructions found in the link and create a pop up calendar which is cooler and easier to use: https://www.fontstuff.com/vba/vbatut07.htm
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    09-08-2014
    Location
    Castlebar, Ireland
    MS-Off Ver
    windows 10/Excel 2019
    Posts
    79

    Re: Inserting drop down calendar in excel 2019

    Many thanks for the reply unfortunately Excel 2019 does not have the option to add in the month view control

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Inserting drop down calendar in excel 2019

    if I am remembering correctly, I had the same issue with 2016. I am not entirely sure, but I think that a date picker instead, as far I remember.
    https://www.ablebits.com/office-addi...er-date-picker

+ 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. Reflect TBF vacancies over 2018-2019/2019-2020 budget year
    By jennah63 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2019, 07:32 PM
  2. Excel 2019 Download
    By Analyst157 in forum Excel General
    Replies: 2
    Last Post: 12-25-2018, 08:57 PM
  3. Replies: 4
    Last Post: 12-22-2018, 02:09 PM
  4. [SOLVED] Excel 2019 functions are not showing
    By ImranBhatti in forum Excel General
    Replies: 10
    Last Post: 11-02-2018, 09:45 AM
  5. Replies: 0
    Last Post: 06-06-2012, 02:36 PM
  6. [SOLVED] how do I add a drop-down calendar in excel?
    By MrsMac2000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2006, 06:35 AM
  7. [SOLVED] How can I set up a drop down box with a calendar in Excel?
    By Peter Newman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 01: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