Hi,
Looking for someone much smarter than me (not hard) to see if they can work out why I'm getting some strange behaviour adding comments to cells using VBA.
Some background: I'm using cell comments within VBA code to create an audit trail when cells are amended. The cells are protected and if a user wants to make a change (e.g. correct a typo) then they have to enter the reason why (into a simple userform) that updates cell comments with their environ username, date, time and reason.
This is the code I'm using at present - which works well up to a point:
c is the cell, just in case that's not clear, and ChngRsn is the text the user enters to explain the reason for the change.![]()
Please Login or Register to view this content.
I can run the above code up to about three times depending on the length of the text and it works really well, but over that then it just doesn't update the cell comments. No error message, steps through the code all fine, NewCmt is not empty - but just doesn't add anymore.
Anyone have any ideas on why this might be - or an alternative I can try to achieve the same end???
Any assistance appreciated - as always.
Thanks, TC
Bookmarks