Automatically Run Macro from a calculated cell value change

Question

Automatically Run Macro from a calculated cell value change

Report

smiller - Updated on Apr 20, 2021 at 07:14 AM
TrowaD

Posts: 2733
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 26, 2021

- 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

Automatically Run Macro from a calculated cell value change
Automatically run macro in excel when cell changes - How-To - Excel
How to transfer data from one excel workbook to another automatically using macro - How-To - Excel
Excel - A macro to increase a cell reference - How-To - Excel
Excel - A macro to perform calculation and save data on another sheet - How-To - Office Software
Excel - A macro to re-arrange cells - How-To - Excel

1 reply

Reply Ask a question

TrowaD · Answer 1 · 2021-04-20T12:21:51-0400

Answer 1 / 1

TrowaD

Posts: 2733
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 26, 2021

460
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

Automatically Run Macro from a calculated cell value change

1 reply

Your reply

Subscribe To Our Newsletter!