title: Trigger an event in Excel VBA from a data validation drop down
body: <p>I have a sheet where I want to give the user a choice of calculation types.  The calculation types are done via a list selection in Data validation.  Once selected, I want it to trigger an event which will then load the correct cells for that type of selection.  How do I detect a data change event on the Data validation drop down or do I need to use the active x control for this?</p>
  
  <p>Code for the worksheet change event not activating:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Cells.count &gt; 1 Then Exit Sub
  
  Application.EnableEvents = False
  
  On Error GoTo Errortrap
  
  
  '~~&gt; Change it to the relevant string with which you want to compare
  StringToCheck = "+"
  
  If Not Intersect(Target, Range("D47")) Is Nothing Then
      '~~&gt; Check for the cell value
      If Target.Value = StringToCheck Then
        'setup row to capture addition fields
         Cells(33, 4).Value = "Input File 1"
         Cells(33, 4).Value = "Worksheet 1"
         Cells(33, 4).Value = "Cell 1"
         Cells(33, 4).Value = "Input File 2"
         Cells(33, 4).Value = "Worksheet 2"
         Cells(33, 4).Value = "Cell 2"
      End If
  End If
  
  LetsContinue:
     Application.EnableEvents = True
     Exit Sub
  Errortrap:
      MsgBox Err.Description
      Resume LetsContinue
  End Sub
  </code></pre>