Question to Chip Pearson
 

Chip,

In my earlier posting, 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

Question to Chip Pearson
 

Doug,

You can use the Change event to capture changes made by the user
or VBA code. You can use the Calculate event to capture changes
made by calculation of the cell:

Private Sub Worksheet_Calculate()
Static OldA1 As Variant
If IsEmpty(OldA1) = True Then
OldA1 = Range("A1").Value
Else
If Range("A1").Value < OldA1 Then
MsgBox "A1 Changed From: " & OldA1 & " to " &
Range("A1")
End If
End If
End Sub



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



"Doug" wrote in message
...
Chip,

In my earlier posting, 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

Question to Chip Pearson
 

Chip,

Thank you. thank you. Thank you.

That makes perfect sense.

Thank you.

Doug