+ Reply to Thread
Results 1 to 1 of 1

Select Multiple Items in Drop-Down Box

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Select Multiple Items in Drop-Down Box

    I am trying to build a drop-down box within Excel that allows for multiple selections. I was able to use some code provided by Contextures (http://www.contextures.com/excel-dat....html#Multiple) to do this. The one addition I would like to make is to also allow users to type in values in addition to being able to choose from the drop down list. However, whenever this code is used in conjunction with allowing users to type in their own responses, the code somehow causes the entry to duplicate the prior entry. For example, if the user selects "Apples" and "Oranges" from the drop down list, the cell will display, "Apples, Oranges". However, if the user now types in the response "Bananas", the cell will now display "Apples, Oranges, Apples, Oranges, Bananas". The way the code is set up, it is somehow copying the original value, and just inserting it before the new value. I'm not sure how to correct this so that the end product only reads "Apples, Bananas, Oranges".

    Any suggestions? I've pasted the code I'm using below.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 12-05-2013 at 04:29 PM. Reason: Added Code Tags

+ 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. Non Select-able Items in Drop Down List
    By Corialis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2012, 02:36 PM
  2. Replies: 1
    Last Post: 05-14-2012, 05:06 AM
  3. Excel Data Validation - Select Multiple Items - Need to Apply Macro to Multiple Rows
    By kristynroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 07:44 PM
  4. Replies: 7
    Last Post: 12-02-2011, 09:56 PM
  5. select multiple items from drop-down menu
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 05-25-2008, 11:50 AM

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