CODEWITHSUNDEEP
excelvbaeventtrigger
Contango
Contango

Reputation: 80428

How do I run some VBA code when a cell is changed?

I want to add some VBA code when the value in a cell changes.

I've already tried Worksheet_Change() as described at Contextures however, this won't work: it only fires when the user changes the value. I want to fire it whenever the value changes, i.e. whenever the spreadsheet recalculates.

Any ideas?

Upvotes: 3

Views: 509

Answers (1)

JeffO
JeffO

Reputation: 8053

Private Sub Worksheet_Calculate()
   MsgBox "Something recalculated", vbOKOnly, "Testing Actions"

End Sub

Upvotes: 5

Related Questions