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
