Automatic execution of a macro with a function cell

[News]

Hello all,

I would like execute a macro when a cell value change
The problem : the target cell have a function and the macro doesn't execute
automatic

This is my code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("G12").Address Then
Call Macro3
End If
End Sub

Thanks for your help
Olivier

 

[Dave Peterson]

Maybe you can use the worksheet_Calculate event???