Can I enter a formula in a comment?

[Trident]

Excel 2003: I want to display some extra detail on a cell when the pointer
runs over it. This is like the "insert comment" function but I want the
detail to come from another cell (e.g. if the cell contains "JS" the edit bow
will show "John Smith", which it looks-up from another cell or worksheet).
Does anyone know if this is possible? Thanks

 

[William DeLeo]

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

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

 

[Trident]

Thanks - that was really helpful.