Change event to Add or update comment with input box when cell in a range is changed

**fratello** · 08-27-2012, 05:50 AM

Hi VBA experts,
I know there are many existing codes on updating comments online, but i am just not fit enough to change those macros to suit my needs. What i am looking for is something similar to this code below (found here: http://www.mrexcel.com/forum/excel-q...t-comment.html), but with multiple ranges such as A:B, D:G, T:Z

Please Login or Register  to view this content.

However, what I would additionally need is an input box, which enables me to enter the comment (without deleting previous comments) when a cell is changed. So in the end, each comment entered into a specific cell in this range would be in the cell that was changed along with the date and time when the comment was edited/created. Is that possible?
Hope you understand what I mean

Thanks a lot

**Leith Ross** · 08-27-2012, 12:06 PM

Hello fratello,

Here is the amended version of the macro. Let me know the results.

Please Login or Register  to view this content.

**fratello** · 08-27-2012, 08:47 PM

Good Morning Leith Ross
Thanks a lot for your post. This works perfectly fine, unless there are more than 5 changes to a cell. *Edit: I guess there is some kind of restriction based on the number of letters in the comment box.
Only the first 5 changes are shown. Is their a way to show the last newest 5 commentaries? Or a way to copy every comment that has been made to a seperate worksheet, so that there is a history?
Thanks a lot

**Leith Ross** · 08-29-2012, 04:40 AM

Hello fratello,

The problem with the comment was it accepts only 255 characters when the string is assigned by the text property. By using the Insert method, the 255 character limit no longer applies. I made a few changes to the macro to address the problem. Let me know the results on your machine.

Please Login or Register  to view this content.

**fratello** · 08-29-2012, 06:40 AM

HI Leith,
Thank u very much. this works perfectly.
A minor detail would be the order of the comments, starting with the newest one and ending with the oldest one. But it is not that important.
Thank u very much

Change event to Add or update comment with input box when cell in a range is changed

LinkBack

Thread Tools

Rate This Thread

Display

Change event to Add or update comment with input box when cell in a range is changed

Re: Change event to Add or update comment with input box when cell in a range is changed

Re: Change event to Add or update comment with input box when cell in a range is changed

Re: Change event to Add or update comment with input box when cell in a range is changed

Re: Change event to Add or update comment with input box when cell in a range is changed

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions