if a cell value ever = false run macro

[aberenguel]

I want excel to run a macro i've created whenever the value of a cell is equal to FALSE. I'm sure this is easy to do but i'm having trouble getting it right.

 

[fridgenep]

...

Hi,

p.e.:

your macro:

Option Explicit

Sub test()
MsgBox "my macro"
End Sub

your worksheet:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If ActiveSheet.Range("A1").Value = False Then test
End Sub