Track multiple changes as a comment

Hey everyone,

I've been struggling with the following problem for a while. I want to change a VBA Code so it doesn't only display the last change made, but in the best case the last 4 or 5 changes made to a cell, as a comment (without having to share the workbook and using the track changes option).

I got the following code so far:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can anyone please help me changing the code so it displays more than just the last change ? I am very glad for any help.

Thanks a lot,

Jan

Dear kvsrinivasamurthy,

this is really great, thanks a lot !! I am sorry I have to bother you again, but could you tell me how I'd have to change the code so it applies f.e. to cells P9-P27 and S11-S18, so basically different rows within columns ?

Furthermore, the comments are always deleted automatically after I saved the file, opened it again and wrote a new number into the cell. Is there a way I can save the comment constantly? That way also if another user opened the file, edited the cell, the last 5 changes made by whom ever are always remembered ?



Again, thanks so much, you deserve an excel medal for this !

Jan

PL see the attached file . I hope this is what you want.

Thanks for compliments once again.Pl mark the thread SOLVED.

A slight change for improvement (to add additional ranges)

In the code for P9:P27 7 & S11:S18 Instead of this

If Not Intersect(Target, Range("P9:P27")) Is Nothing Or Not Intersect(Target, Range("S11:S18")) Is Nothing Then

This can be used

If Not Intersect(Target, Range("P9:P27,S11:S18")) Is Nothing Then