MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comment Tracker in Excel?


Posted by Rob on May 31, 2001 5:17 PM

Hi,
I'm sure someone sometime has set up some type of comment trackage page in excel. I was looking for any ideas on how to improve/revamp mine. Take a look at it here: Notes


It does a nice time stamp, but the problem is, I don't like how you can not continue a previous comment without entering a new cell, and making a new time stamp, it makes a full page look confusing.

Any ideas/help would be appreciated.

thanks,

Robert


Posted by David Rainey on June 01, 2001 7:52 AM

It does a nice time stamp, but the problem is, I don't like how you can not continue a previous comment without entering a new cell, and making a new time stamp, it makes a full page look confusing.

I am sorry to tell you this but that seems awful.
It didn't even work for me.

If you want help from a jerk like me then send me a sample that looks confusing like you want it too.

Also send it the way that a user would see it as well as a better explanation of why you are using it.

Posted by Wilf on June 01, 2001 8:09 PM

It does a nice time stamp, but the problem is, I don't like how you can not continue a previous comment without entering a new cell, and making a new time stamp, it makes a full page look confusing.


1. Instead of merging the cells in columns D:J, use only column D for your Comments (enlarge the width of column D to the width you would like).
2. Use column E for your Initials.
3. Format column D as "Wrap Text"
4. In your Worksheet_Change procedure after the line that reads 'If Target <> "" Then', add the following line :-
Target.EntireRow.Autofit