+ Reply to Thread
Results 1 to 3 of 3

Formula to select multiple values from a drop down list

  1. #1
    Registered User
    Join Date
    06-01-2017
    Location
    Bucharest
    MS-Off Ver
    2016
    Posts
    2

    Formula to select multiple values from a drop down list

    Good afternoon,
    Really thankful if somebody could help with the following: From the drop down list in Calendar View (C2) when I select any item it will specify the dates of action due to "Steams Visit Tracker" page in the Calendar Table underneath. I want to select more than one item from the drop down list so it can select multiple output at the calendar.
    Help would be really appreciated.
    Many thanks,
    KingOfNoWhere
    Attached Files Attached Files

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: Formula to select multiple values from a drop down list

    I think that you are storing up problems for yourself...

    Please Login or Register  to view this content.
    This will return the dropdown you wanted. I really am not sure how you can then adjust your CF formulae.... I can plagiarise bits of code... I can't write any!!
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 06-02-2017 at 02:40 AM.
    Glenn



  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,797

    Re: Formula to select multiple values from a drop down list

    With regular DV (dropdown), you can select 1 item at a time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Select multiple options from drop down list
    By forestview in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2016, 01:42 PM
  2. Select multiple options from drop down list
    By nsprasad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2015, 05:30 AM
  3. Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  4. Drop Down list to select Chart x axis values
    By rlg50 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-07-2013, 11:52 AM
  5. Multiple select drop down list
    By boc_est1986 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2009, 08:07 AM
  6. [SOLVED] with a drop down list in excel how do I select multiple values
    By Keith H in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 01:15 PM
  7. Replies: 5
    Last Post: 10-27-2005, 01:55 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