+ Reply to Thread
Results 1 to 4 of 4

Create A Validation List

  1. #1
    Registered User
    Join Date
    03-03-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    39

    Create A Validation List

    Hi all,
    I have a list of letters in a column ie. A2 = A, A3 = B, A4 = C and so on.
    What I want to do is add all of these letters to a drop down validation list in a cell.
    I can do this fairly easily but only by adding each row as a different value (i.e. the user will have to chose between A, B or C).
    What I want is for the user to be able to chose any combination of the letters (i.e. AB, AC, BC, etc).
    I have found the following example on the internet:
    Please Login or Register  to view this content.
    However, this does not return only the unique combinations (i.e. it returns ABC and CBA).

    Can anyone advise me on how to do this?

    Once I have all of the possible combinations, my plan is to use them to create a string and add that to the validation list in the cell.

    I hope all of this makes sense?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Create A Validation List

    There's a workbook at https://app.box.com/s/b9b9fc06beb63b9562f9 that will generate combinations in lexical order.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Create A Validation List

    Please Login or Register  to view this content.
    Last edited by snb; 10-13-2013 at 02:09 PM.



  4. #4
    Registered User
    Join Date
    03-03-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Create A Validation List

    Thanks snb (AGAIN!)
    It always take me a while to decipher your code but it always turn out to be the most logical and efficent way of achieving what I need.

+ 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. Replies: 3
    Last Post: 05-23-2013, 06:23 AM
  2. Replies: 4
    Last Post: 02-15-2012, 12:11 PM
  3. Excel 2007 : Data Validation - Cannot create List
    By oopsieny in forum Excel General
    Replies: 3
    Last Post: 08-16-2010, 12:46 PM
  4. [SOLVED] How to create a Sub validation list in excel?
    By Simon in forum Excel General
    Replies: 1
    Last Post: 07-13-2005, 06:05 AM
  5. create sublist from validation list
    By soasi in forum Excel General
    Replies: 0
    Last Post: 03-13-2005, 04:35 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