title: Activate a Macro each time I use a Validation List in Excel
body: <p>I have a Validation List that selects different countries. Each country has different sellers and I have to make a Validation list for them too. The problem is that I have to run a macro manually (with a button) each time I select a different country. I want the macro to run/activate each time I use the country validation list and not manually(button).</p>
  
  <p>I don't think any of the code I'm using is needed to solve my problem. I'll post the last part anyway.</p>
  
  <pre><code>Dim strFormula1 As String
  
  strFormula1 = "=$z$1:" &amp; Worksheets("graficos").Range("z1").End(xlDown).Address()
  
  
  With Selection.Validation
      .Delete
      .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
      xlBetween, Formula1:=strFormula1
      .IgnoreBlank = True
      .InCellDropdown = True
      .InputTitle = ""
      .ErrorTitle = ""
      .InputMessage = ""
      .ErrorMessage = ""
      .ShowInput = True
      .ShowError = True
  End With
  </code></pre>