Results 1 to 4 of 4

Multiple data selection from drop down list --> to single cell

Threaded View

  1. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Multiple data selection from drop down list --> to single cell

    Worksheet_change event is used.Pl see file.
    K5 Validated cell, M5 is the destination cell.
    If M5 is not having the value of K5, then pnly it will add. This avoids duplication.
    code
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$K$5" Then
    
    Application.EnableEvents = False
        If InStr(1, Range("M5"), Range("K5")) = 0 Then
        Range("M5") = Range("M5") & "," & Range("K5")
        End If
    
    Application.EnableEvents = True
    End If
    End Sub
    Last edited by kvsrinivasamurthy; 12-09-2014 at 08:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-22-2014, 02:39 AM
  2. Replies: 10
    Last Post: 05-22-2014, 11:36 AM
  3. [SOLVED] Returning data across multiple sheets based on drop down list selection
    By rooboyz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 02:41 AM
  4. Excel VBA multiple selection drop down data validation list
    By garoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 05:20 PM
  5. Populate data in cell based on drop down list selection
    By dwoodson297 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2013, 02:07 PM

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