Track multiple changes as a comment in Excel

[tomi85]

Hello Everyone,

I'm trying to capture the last five changes under comments in Excel via VBA code but I been unsuccessful. I noticed an old thread that had a similar request but has no details for who made the change and the date/time associated with the change.
What I would like is a similar outcome as the code below but I would like to capture the last 5 changes. The code below capture instantaneous changes only. If the same data is captured for the last 5 changes and is not deleted when the file is closed, that would be great.

Please Login or Register  to view this content.

Thank you in advance for your help!
Tomi

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[tomi85]

Complete, my mistake

[zbor]

Didn't test it but just to give you idea.

Do you want to save previous comment first and then add new to it?

Please Login or Register  to view this content.

[tomi85]

Yes, Zbor. I would like to save the previous 4 comments. Essentially, I would like the comment to display the last 5 edits including date/time and the user.

Thanks,
Tomi

[tomi85]

Yes, Zbor. I would like to save the previous 4 comments. Essentially, I would like the comment to display the last 5 edits including date/time and the user.

Thanks,
Tomi