My spreadsheet contains a column with data validation that I have inserted code (below) that will allow multiple selections. Is there additional code that will allow the drop down list to stay open while selecting the multiple selections. Currently, I have to select one and then go back and click the drop down arrow again in order make another selection. It would be ideal if the list would stay open during the multiple selections.
Any assistance is appreciated.
Margaret
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 = 12 Then
If Oldval = "" Then
Else
If Newval = "" Then
Else
Target.Value = Oldval & ", " & Newval
End If
End If
End If
End If
exitHandler:
Application.EnableEvents = True
End Sub
Bookmarks