Run macro on cell change

[condatis]

How do you run a macro automatically when you change a cell? For instance, i have a macro that does an autofilter called Filtermacro and a cell E2 on worksheet sheet1 that is a drop down box of 200 items. I want the macro to run when i change it from the item on that dropdown. Any help? I know it has something to do with worksheet change event but I'm horrible at coding.

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "E2" Then Call MyMacro
End Sub

Change MyMacro to the name of your macro.

 

[condatis]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "E2" Then Call MyMacro
End Sub

Change MyMacro to the name of your macro.

Genius! I love this forum.