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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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.
 
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
 
Back
Top