+ Reply to Thread
Results 1 to 5 of 5

Dropdown calendar

  1. #1
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    67

    Dropdown calendar

    How to create a drop down monthly date calender in excel? I have seen few videos in youtube different ways of doing this. What is the best way to do this?Any help greatly appreciated

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,161

    Re: Droptown calender

    attached is a file with a calendar form embedded in the VBE. There are three formats available. Click on Alt F8 to run each one.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    67

    Re: Droptown calender

    Many thanks, I opened your sheet but what are the steps to add a drop down calender? Sorry, I am bit amateur in this regard

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Dropdown calendar

    @bananacitizen
    You will need a bit of VBA if you want an automatic pop-up in specific cells
    Here is a simple example
    - Test in attached file (alansidman's file with code below added)
    - Select any cell A2 to A100 and (basic calendar) pop-up appears
    - To find the code RightClick sheetTab \ ViewCode
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kev_; 04-17-2018 at 10:45 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Dropdown calendar

    @alansidman - thanks for sharing - very useful (and circumvents the regular issue with MSWindowsCommonControls)

+ 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. Calendar dropdown box in Excel 2010
    By Pami in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2015, 08:32 AM
  2. Cascading Dropdown for A Calendar
    By pspunlimited in forum Excel General
    Replies: 17
    Last Post: 02-05-2015, 03:44 AM
  3. Need calendar dropdown or pop up box for a column
    By uglymaggot in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-21-2014, 11:11 AM
  4. DropDown Calendar
    By contaminated in forum Excel General
    Replies: 16
    Last Post: 05-22-2014, 01:57 AM
  5. Calendar Dropdown
    By Amit Chugh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2013, 08:17 PM
  6. Excel 2007 : Inserting a Calendar into a Dropdown
    By lsbelt in forum Excel General
    Replies: 2
    Last Post: 03-29-2011, 03:26 PM
  7. Can I create a dropdown that will show a 2-month calendar?
    By Vecchia in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

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