Excel--Can you select multiple selections in a drop down list?
 

Is there a method to multi-select from a drop down list? (Choose and display
more than one selection from the list)

Excel--Can you select multiple selections in a drop down list?
 

Use a listbox instead???

Nukeman wrote:

Is there a method to multi-select from a drop down list? (Choose and display
more than one selection from the list)

--

Dave Peterson

Excel--Can you select multiple selections in a drop down list?
 

If you don't wish to use a ListBox and stick with Data Validation.

Download a sample workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.

As written it creates a comma delimited list of selected entries.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 11:41:00 -0800, Nukeman
wrote:

Is there a method to multi-select from a drop down list? (Choose and display
more than one selection from the list)

Excel--Can you select multiple selections in a drop down list?
 

http://boisgontierjacques.free.fr/fi...Successifs.xls

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$2" And Target.Count = 1 Then
Application.EnableEvents = False
p = InStr(Target.Offset(0, -1), Target.Value)
If p 0 Then
Target.Offset(0, -1) = Left(Target.Offset(0, -1), p - 1) & _
Mid(Target.Offset(0, -1), p + Len(Target.Value) + 1)
If Right(Target.Offset(0, -1), 1) = ":" Then
Target.Offset(0, -1) = Left(Target.Offset(0, -1), Len
(Target.Offset(0, -1)) - 1)
End If
Else
If Target.Offset(0, -1) = "" Then
Target.Offset(0, -1) = Target
Else
Target.Offset(0, -1) = Target.Offset(0, -1) & ":" &
Target.Value
End If
End If
Target.Value = Target.Offset(0, -1)
Application.EnableEvents = True
End If
End Sub

JB
http://boisgontierjacques.free.fr/


On 9 fév, 20:41, Nukeman wrote:
Is there a method to multi-select from a drop down list? (Choose and display
more than one selection from the list)