VBA Worksheet Event when cell changes by formula

[mizogy]

Hi All

Wondering whether anybody would be able to shed some light to whether it is possible to trigger a worksheet event when a cell changes through formula as opposed to the cell being change manually?

Many thanks,

Mizogy

The code I have so far;


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("AQ11")) Is Nothing And Target.Cells.Value > 0 Then
Exit Sub

Dim a As Variant
a = Range("AQ11")
If a = 0 Then
MsgBox "Country selected has no salary data to base an indexation, therefore data is unstable to use", vbExclamation, "Information Alert"
End If
End If
End Sub

 

[RoryA]

For worksheet events, only the Calculate event is applicable, but it will not tell you what calculated, or whether the value actually changed, so you need to test that. You may wish to monitor the input cells (if any) instead.

 

[VoG]

Try

Private Sub Worksheet_Calculate()
If Range("AQ11").Value = 0 Then MsgBox "Country selected has no salary data to base an indexation, therefore data is unstable to use", vbExclamation, "Information Alert"
End Sub

 

[mikeymay]

I appreciate this is a few years old but I want to do the same but across several cells withing a named range.

Is this possible?


TIA