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

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" wrote in message
...
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

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