Automatically Run Macro from a calculated cell value change

Solved/Closed
smiller - Updated on Apr 20, 2021 at 07:14 AM
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
- Apr 20, 2021 at 12:21 PM
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
Related:

1 reply

TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
Apr 20, 2021 at 12:21 PM
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
0