Excel Drop Down List Multiple Selection

Excel Drop Down List Multiple Selection

https://softtechtutorials.com/microsoft-office/excel/excel-drop-down-list-multiple-selection/

0:00 Intro 0:26 Inserting Excel Drop Down List 1:06 Opening VBA 1:40 VBA Code Multiple Selection 2:24 Initializing variables 2:41 Checking for changes in the drop down lists 3:22 Multiple selected items

Multiple Selection Code:

Private Sub Worksheet_Change(ByVal Target As Range)

' Initializing variables Dim oldVal As String Dim newVal As String

' Checking for changes in the drop down lists

Application.EnableEvents = True

If Target.Address = "$G$2" Or Target.Address = "$G$3" Then

If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then
    Exit Sub

' Adding the multiple selected items to the list Else If Target.Value = "" Then Exit Sub

    Else
        Application.EnableEvents = False
        newVal = Target.Value
        Application.Undo
        oldVal = Target.Value
        If oldVal = "" Then
            Target.Value = newVal
        Else
            If InStr(oldVal, newVal) = 0 Then
                Target.Value = oldVal & ", " & newVal '& vbNewLine &
            Else
                Target.Value = oldVal
            End If
        End If
    End If
End If

End If

Application.EnableEvents = True

End Sub

In this tutorial, I will explain how to create a drop down list that is dependent on the answer to another drop down list. We will do this without using any complex formulas.

Above, you can find the code that is used in this video. Feel free to use and adjust it as suits best for you.

This concludes our Excel drop down list multiple selection tutorial.

#Excel #Tutorials #HowTo ... https://www.youtube.com/watch?v=ELtmqeOgOBg