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

[Monami]

Hi,

need help please
i'm trying to create a drop down list which enables multiple selections,
which those selections will appear in a single cell, separated by commas.

thanks

[PeteABC123]

Monami My Friend, could you post a sample workbook? Before & after? ??

Pete

[Monami]

Hi Pete,
i wasn';t able to upload a file - hope the screen shot illustrates my question better
thanks,
M

Capture.PNG

[kvsrinivasamurthy]

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