Automatically Run Macro from a calculated cell value change [Solved]

Report
-
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 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
Related:

1 reply

Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
465
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!