Solved: Run Macro on Cell Change

[gimli]

Hey all,

Im looking to run a macro when a cell value changes.

ex

When cell F9 changes (any change) run macro sub Candyman ().

Thanks much ahead of time

[mdmackillop]

[VBA]
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Exits
Application.EnableEvents = False
If Target.Address = "$F$9" Then
Call Candyman
'do other stuff
End If
Exits:
Application.EnableEvents = True
End Sub

[/VBA]

[gimli]

Excellent! Thanks much