+ Reply to Thread
Results 1 to 6 of 6

Multiple Selections from Lists

  1. #1
    Registered User
    Join Date
    05-28-2015
    Location
    Lakeland, FL
    MS-Off Ver
    Excel 13
    Posts
    66

    Multiple Selections from Lists

    In columns L-T are all lists. Is there a way to create lists in each cell where you can select more than one item? I have attached an example worksheet. I will take any advice! Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,010

    Re: Multiple Selections from Lists

    Here are the instructions: LINK

    The steps are many .,.. too many to describe here.

  3. #3
    Registered User
    Join Date
    05-28-2015
    Location
    Lakeland, FL
    MS-Off Ver
    Excel 13
    Posts
    66

    Re: Multiple Selections from Lists

    PHP Code: 
    Private Sub Worksheet_Change(ByVal Target As Range)
    ' Developed by Contextures Inc.
    www.contextures.com
    Dim rngDV 
    As Range
    Dim oldVal 
    As String
    Dim newVal 
    As String
    If Target.Count 1 Then GoTo exitHandler

    On Error Resume Next
    Set rngDV 
    Cells.SpecialCells(xlCellTypeAllValidation)
    On Error GoTo exitHandler

    If rngDV Is Nothing Then GoTo exitHandler

    If Intersect(TargetrngDVIs Nothing Then
       
    'do nothing
    Else
      Application.EnableEvents = False
      newVal = Target.Value
      Application.Undo
      oldVal = Target.Value
      Target.Value = newVal
      If Target.Column = 12 Then
        If oldVal = "" Then
          '
    do nothing
          
    Else
          If 
    newVal "" Then
          
    'do nothing
          Else
          Target.Value = oldVal _
            & ", " & newVal
    '      
    NOTEyou can use a line break,
    '      instead of a comma
    '      
    Target.Value oldVal _
    '        & Chr(10) & newVal
          End If
        End If
      End If
    End If

    exitHandler:
      Application.EnableEvents = True

    End Sub 
    How do I repeat that code so it works not only for Column L but Column L-T?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,010

    Re: Multiple Selections from Lists

    Try:

    Please Login or Register  to view this content.
    Change to:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-28-2015
    Location
    Lakeland, FL
    MS-Off Ver
    Excel 13
    Posts
    66

    Re: Multiple Selections from Lists

    That worked perfect! Thank you!

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,010

    Re: Multiple Selections from Lists

    Great! Cheers

+ 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. Drop down lists dependent on 2 prior selections
    By Suicyco in forum Excel General
    Replies: 6
    Last Post: 04-29-2016, 05:34 PM
  2. [SOLVED] second level sorting using selections from droop down lists
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-31-2014, 06:32 AM
  3. output dependent on selections from 2 drop down lists
    By Mlacour in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 12:08 PM
  4. List Box Selections Outputting Multiple Selections with One Click
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-21-2011, 12:27 PM
  5. Multiple selections from a pick list - only unique selections (no repeats) ?
    By opsayo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2011, 06:25 PM
  6. automatically synching selections from two validation lists
    By priyabrata in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2007, 03:06 AM
  7. [SOLVED] Making multiple selections from Excel drop down lists
    By Andyroo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-16-2006, 10:25 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