Run a Macro changing the option of a Drop Down List

[krausobe]

I have a macro that clear the data from some specific cells and i want it to be trigger every time a change the option from a drop down list. How could I do that?

thanks!

 

[Momentman]

Assuming the dropdown is in cell C1 then

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("C1")) Is Nothing Then
        'Call MacroName 
   End If
End Sub

 

[krausobe]

Thanks for the answer! where should I put this code? in the worksheet code? i tried that but nothing happened when i choose another option of the drop down list.

thanks!

 

[Momentman]

Is your dropdown list from data validation?

Right click the Sheet tab, select "view code" and paste the code in there i.e "Worksheet_Code"