comments in a cell

Giganews Newsgroups
Subject: comments in a cell
Posted by:  Steve (instructo…
Date: Wed, 25 Mar 2009


Just a question?

is there any way of using some vba that will add coments to a cell and
have the comment box appear as it does if i add my own comments
manually, would like the comment hidden until the cell is selected and
then have it show up!

obviously i know this happens when you manually process comments, but
i would like the comment box to appear and display values that are in
another worksheet within the same workbook.

hope that makes sense.