Thread: cell comment
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Sons Jack Sons is offline
external usenet poster
 
Posts: 144
Default cell comment

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