I want to have more than one dropdown multiple selection list in my worksheet. I currently have it in B14, but i want the same code copied to include the same list in C14 and D14 etc. Right now, I have this:
Also...Is there anyway to have more than one multiple selection dropdown list in the same worksheet?Private Sub Worksheet_Change(ByVal Target As Range) Dim oldVal As String Dim newVal As String If Target.Address(0, 0) <> "B14" Then Exit Sub On Error GoTo ReEnable Application.EnableEvents = False newVal = Target.Value Application.Undo oldVal = Target.Value Target.Value = newVal If oldVal <> "" And newVal <> "" Then Target.Value = oldVal & ", " & newVal End If ReEnable: Application.EnableEvents = True End Sub
Thank you!
Aliya
Bookmarks