hi,
Debra has done a little work in that area. she her web site.

http://www.contextures.com/xlcomments03.html

regards
FSt1

"Mark" wrote:

Hi,

I want to add various canned comments for a cell(s) based on evualating a
simple formula. For example .... if (A2+ A3) A7 then add a comment to the
cell A7 with "canned" text.

Thanks!!