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

Run macro when cell value changes by formula
Run macro when cell value changes - Best answers
Run macro automatically when cell value changes - Best answers
How to run macro when data entered in a cell - Guide
Vba run macro when cell value changes by formula - Forum - Excel
Excel increment cell value by 1 formula ✓ - Forum - Excel
If cell contains date then formula ✓ - Forum - Office Software
If cell color is then formula excel - Guide

1 reply

Answer 1 / 1

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

Similar discussions

Execute Macro On Calculated Cell change

Formula to subtract one cell value from another.

Use of '@' in formulae

Excel - Repeat rows to a specific number of times

Conditional formatting: change fontcolor based on another cell

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!