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