Select multiple options from drop down list

Hi

Not sure if this is possible or if it requires VBA which I am not familiar with.

I want to have a drop list in a cell that I can select more than one item which will display in the same cell can this be done?

I would appreciate any guidance in the right direction.

Thanks

Forestview,

Attached code from Contextures Inc. lets you choose item from dropliat, then choose subsequent items which are added to cell separated by commas.
Includes oprion to use a line break instead of a comma.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

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(Target, rngDV) Is Nothing Then
   'do nothing
Else
  Application.EnableEvents = False
  newVal = Target.Value
  Application.Undo
  oldVal = Target.Value
  Target.Value = newVal
  If Target.Column = 1 Then
    If oldVal = "" Then
      'do nothing
      Else
      If newVal = "" Then
      'do nothing
      Else
      Target.Value = oldVal _
        & ", " & newVal
'      NOTE: you 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

Hope this helps

Ochimus

Hi Ochimus

It only seems to select and replace the numbers as would happen with a Validation List doesn't do as stated in point 4!

Am I missing something?