title: Why is my second VBA on my sheet not working
body: <p>I have a VBA for another reason already in my sheet, however i want a VBA on the same sheet that now allows me to select multiple options on a drop down, please tell me why this does not work? I simply want column 20 to be the area that the 2nd VBA works on</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  On Error Resume Next
  If Target.Column = 1 Then
    If Target.Validation.Type = 3 Then
     Application.EnableEvents = False
     Target.Offset(0, 1).ClearContents
    End If
  End If
  
  exitHandler:
    Application.EnableEvents = True
  
  Dim Newvalue As String
  
  On Error GoTo Exitsub
  If Target.Column = 20 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
              Target.Value = Oldvalue &amp; ", " &amp; Newvalue
          End If
      End If
  End If
  Application.EnableEvents = True
  Exitsub:
  Application.EnableEvents = True
  End Sub
  </code></pre>