Dear All,
Searching the forum I found the code to date stamp the comment but what I need is a bit different and unfortunately more complicated.
Say I have validation drop down menu in Coumn A, Column C and Column E to choose from: Sent, Received, Returned, Processed. There are about 6 different users who use this spreadsheet and I need a user specific and action specific date stamp as many time as the values in A, C,and E are changed - to be tracked and displayed preferably in the comment. If not, then a separate table might work. There are about 80 rows of data.

Thanks in advance,
Art

rtour957 wrote:

Searching the forum I found the code to date stamp the comment but what
I need is a bit different and unfortunately more complicated.
Say I have validation drop down menu in Coumn A, Column C and Column E
to choose from: Sent, Received, Returned, Processed. There are about 6
different users who use this spreadsheet and I need a user specific and
action specific date stamp as many time as the values in A, C,and E are
changed - to be tracked and displayed preferably in the comment. If not,
then a separate table might work. There are about 80 rows of data.

I'm not sure what "comment" you mean, but I'm going to assume you want some
sort of logging. Have a look at the logging code I posted last year, in the
thread called "Macro to create log file". The current version of the code can
be downloaded he

http://auric.altervista.org/excel/track_changes.bas

The code in that file needs to go into the ThisWorkbook class of the workbook
being tracked. It's in the public domain so feel free to change it as you
desire... if it does what you need it to, that is. (It tracks *everything*,
not just 3 columns.)

--
Courage of the heart is very rare.

Thanks for the link I checked out. I do not want a log be created in another sheet. I thought about having comment in the cell created that would be date stamped with the user ID and cell value that the user chose from the drop down menu in that cell.
Any suggestions?

Thank you , Art

Refer to the attached, it will put the date and user name as comment in any cell that is changed.

Hope it helps

Thank you,
It does almost exactly what I need but does not keep the log of previous changes/date stamps. The values in the cell may change several times. So everery time it changes I need a date stamp that would stay and any future date stamps would be recorded on top of the previous ones - to keep a log.
Also preferebly a specific action/cell value that cause the date stamp be recodred as well.
I attached small file and manually formatted comments in few columns to make it easy to understand what I am looking for.

Respectfully,
Art

Will have a look at it later as I am at work at the moment. Also can I ask why you specifically want it in the Comments v a seperate log? I am not an expert but I suspect that the comments box will have a limit to the number of characters, so I am worried you will reach this limit. Also adding comments to every cell will increase your file size etc.