title: Run Event Macro After Data Validation Selection
body: <p>I built up a data validation list on the sheet called report, I need to run a macro each time I select an item from the list. Now that I have this code below, but it doesn't work. It does run in VBA, but it will not run when I choose the Item in my worksheet, it seems like I didn't refer to the macros</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      If Target.Address(True, True) = "$B$3" Then
          Select Case Target
               Case "ABCP"
                  Call Macro1
               Case "Accounting Policy"
                  Call Macro2
               Case Else
                    'Do Nothing
          End Select
      End If
  End Sub
  </code></pre>