I found a couple ways to use a macro for this
(http://www.mvps.org/dmcritchie/excel/ccomment.htm) but no way to have
an active formula that updates the comment based on the contents of
another cell.

I'd definitely use such a method if anyone else knows if this is
possible (one page I saw said it was not possible btw).


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=383468