Convert Macro to PrivateSub

[HotNumbers]

Can someone please tell me how i can change the code below to work on the worksheet and to be a privatesub or function. What i mean by this is i want the macro to run as soon as cell E8 is changed.

Sub AutFilterLogic()
'
' Macro21 Macro
'

Sheets("ZICO InputSheet").Select

Range("A17:S17").Select
Selection.AutoFilter
Selection.AutoFilter Field:=19, Criteria1:=Range("E8").Value

Beep


End Sub

 

[Joe4]

You want to use an Event Procedure. See here: http://www.mrexcel.com/articles/macro-when-excel-cell-changes.php

 

[HotNumbers]

Perfect.... Thanks a million.