PDA

View Full Version : Solved: Run Macro on Cell Change



gimli
04-21-2010, 10:45 AM
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
04-21-2010, 10:55 AM
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

gimli
04-21-2010, 11:04 AM
Excellent! Thanks much

:thumb