ExcelBanter - Automatically calculate in a cell comment

It would be a lot simpler and would be updated properly
if you simply used another column than using a macro.

This is the programming group so I guess you really do want
a programming solution. I would still suggest using another
column and something more oriented to your actual goal, which
I can only guess at.

Read about Event Macros
http://www.mvps.org/dmcritchie/excel/event.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Maddoktor" wrote in message ...
Hi all,

Is it possible to have a calculation that calculates a figure and then
have the answer appear in the cell's comment field.

Thanx in advance.