When a value is changed manually or dynamically in a cell, how can I tell?

D

Doug

I have been using the following to monitor for changes in cells in my excel spreadsheet:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

But I am unsure if this monitors manual key entry, as well as automatic changes to cells (if I manually modify F1, and the values of F2, G3, h56 and i44 are based on F1, they will get modified). Can someone tell me if I am wrong or right? And if I am wrong, what can I use that will monitor for both automatic changes to cells and manual changes to cells? Thank you.

Doug
 
C

Chip Pearson

Doug,

The Change procedure is triggered when a cell is changed manually
or by VBA code, but not when the value is changed as a result of
a formula calculation.


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




Doug said:
I have been using the following to monitor for changes in cells in my excel spreadsheet:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

But I am unsure if this monitors manual key entry, as well as
Click to expand...
automatic changes to cells (if I manually modify F1, and the
values of F2, G3, h56 and i44 are based on F1, they will get
modified). Can someone tell me if I am wrong or right? And if I
am wrong, what can I use that will monitor for both automatic
changes to cells and manual changes to cells? Thank you.
 
D

Doug

Chip,

Thank you for clarifying what the Change procedure does and how it operates.

Can you recommend what I can use to "trap" both manual changes, changes made via VBA code and when a value is changed due to a formula calculation?

Thanks.

Doug
 
Top