I can't seem to get this working. The comments should only be attached to the cells that change and only to cells in the specified columns. Somehow when I run this code, it does change the other comments in the sheet, but doesnt attach the comment to the cell that has changed. I need to restrain the comments to specified columns, based on changes made in that column, either by the user or if the result changes due to references being changed. A bit tricky to explain, but hope you get the point.
I have now played a bit around with it and now I can see how it works.
The code monitors changes in the columns specified and if something in those columns change, ALL comments in the worksheet is altered to display the content of the cell that it is attached to.
In my case where I have a lot of help comment attached to cells all around in my worksheet I need to be able to control which columns comments are affected by this macro.
Also, if there is no comment attached to the cell in the column that needs a comment, it has to be created. I have over 1000 rows in my sheet, so I need the code to automaticly add a comment, if none is present.
As far as I can see, the automatic size function works, but it doesnt make line breakes, so a very long text is in one line. How can I define how many characters there can be in a result of a formula, before its put down to the next line in the comment?
In advance, thanks a lot for your help!
message edited by JacobJ