Thread: cell comment
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default cell comment

hi,
not sure if this will help but Debra Dalgleish's site has
some code on comments. i haven't been there in a while but
you might try it.
http://www.contextures.com/xlcomments03.html


-----Original Message-----
Hi all,

A1 has a cell comment containing a number, say, 5 (or is

content of a
comment "text" by default?)
If I enter a value (number) in A1 (say 7) I want after

the entry the cell
content to be the sum of the original content (5) and the

entry in A1, so
after that in A1 is 7 and in the cell comment is 12.

I tried all kinds of things, succeeded in putting cell

content in comment,
also adding cell comment to cell content, but not what I

described above
(adding cell content to comment).

Your help will be appreciated.

Jack Sons
The Netherlands


.