Automatically Run Macro from a calculated cell value change

Solved
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I am not having any luck using this code(and haver tried others).

Private Sub Worksheet_Change(ByVal Target As Range) 
If Target.Address = "$V$4" Then 
Call VALIDATION_LOOKUP 
End If 
End Sub


I need to automatically start a Macro then the value of a cell that contains a calculation changes.

Thanks

System Configuration: Windows / Chrome 90.0.4430.72

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Smiller,

Don't look at the cell that contains the calculation, but rather at the cells that make the calculation change.

or

Try using the calculate event: Private Sub Worksheet_Calculate()

Best regards,
Trowa