Is an event triggered when a cell value changes?

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
 
A

Arvi Laanemets

Hi

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

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
VBA word change keys 0
Macro to insert a line when a value changes in a range 1
Drop down list control value in vba 2
VBA to create stock analytics display 1
VBA insert comment only when cell in a range changes first time 5
Interesting Excel 2007 ComboBox trigger for no reason 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top