Is an event triggered when a cell value changes?

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I would like to run a sub when the value is several cells changes,
independently. Is there an event triggered when this happens that I can
use to initiate my procedure?


Thank you much,

Shar
 
Hi

Worksheet's Change event is triggered, whenever a change is made on sheet.
 
Sharon,

The Worksheet_Change event is triggered when a cell's value is
changed either by the user or by VBA code, but not if the change
is the result of a formula calculation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top