Macro deletes multiple lines of comments.

[impala096]

I set up a macro that will timestamp and insert user name before inputting notes. Problem is the comments field can balloon to 10+ lines and the macro begins to delete data once there are more then 7 lines of comments. The attached spreadsheet details the problem i'm dealing with.

[blane245]

Question 1 - I think what is happening to you is that the limiting for cell text in Excel 2003 is 256 characters. You might try changing ActiveCell.Text to ActiveCell.Value is see if that works better. I can't confirm this as I am now runing Excel 2010.

Question 2 - Excel has no mean to signal event to a cell while it is being modified so you can't invoke the macro while in the middle of editing a cell. You can, however, do what you need after existing the cell. See the Worksheet Change event for a possible way ahead. You will need to develop rules about what cells to annotate to do this automatically.

[impala096]

Blane,

In regards to question #1, changing the code to ActiveCell.Value appears to have worked like a charm. It's no longer overriding the comments field.

Thanks for your timely response and simple resolution to this annoying problem i've dealt with for months now!