how to create a drop down list in excel with multiple selections for entire column?

[D_Holmes]

Hi All,

I want to add a drop down list with multiple selections but for the entire column.

Here is the code I have so far:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Oldvalue As String
Dim Newvalue As String
Application.EnableEvents = True
On Error GoTo Exitsub
If Target.Address = "$J$3" Then
If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then
GoTo Exitsub
Else: If Target.Value = "" Then GoTo Exitsub Else
Application.EnableEvents = False
Newvalue = Target.Value
Application.Undo
Oldvalue = Target.Value
If Oldvalue = "" Then
Target.Value = Newvalue
Else
If InStr(1, Oldvalue, Newvalue) = 0 Then
Target.Value = Oldvalue & ", " & Newvalue
Else:
Target.Value = Oldvalue
End If
End If
End If
End If
Application.EnableEvents = True
Exitsub:
Application.EnableEvents = True
End Sub

 

[ranman256]

you dont. drop downs are for 1 choice. (hence the design)
listboxs you can set to multiple in the property.

 

[Akuini]

@D_Holmes
Try using a free Excel add-in called "Search deList". You can find it here:

Search deList

This new version has some additional features, some of them:

• Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
• Sort the list by original order or ascending order.
• Widen or shorten the combobox width at run time.
• Insert multiple entries into the cell.