Timestamp Entered Into Comment Field Whenever Corresponding Cell Changes

Hello Excel gurus,

I'm quite new to VBA in Excel and I am working through some steps in a clumsy manner. Things are moving along pretty good so far and I'm excited about all the powerful additional functionality in Excel through the use of VBA.

Here is my request. When information is entered into a cell, I would like to have the corresponding comment field record a date stamp. If data entered in this cell is changed, I would like to append a new date stamp in the next row of the comment field. So if the cell has been changed 8 times, the comment field would have 8 date and time entries.

It would be great to see a global solution where all cells are treated in this manner. However, in case the data size bogs down the spreadsheet, could a solution also be provided where a particular column of data would have this option? Additional columns can then be added in the VB code to make them behave the same way.

Thank you in advance for your help.

TV

Edit: Sorry for the late addition but is it possible to record the data being entered into the comment field next to the date? This way a history of values can be seen.