how to perform a calculation on the excel's comments?
right click on the excel worksheet we can post a comment on it, but can we post a calculation on the comment just like other normal cells?
2007-01-28 11:24:25 · 2 answers · asked by stanley w 2 in Computers & Internet ➔ Software
dude
u did not answer my question
2007-01-28 12:39:25 · update #1
In Microsoft Excel, you can not create dynamic comments.
You can use the VBA to create comments for any cell based on a calculation
AGAIN
This will not be a dynamic comment, it is static, meant it will not change when you change the source values?
Enjoy my profile, I am the VBAXLMan
2007-01-28 20:34:59 · answer #1 · answered by Anonymous · 1⤊ 0⤋
M$ may consider your idea in version 12 perhaps. For now, create fake comment boxes and use the underlying cell formula.
2007-01-28 22:45:31 · answer #2 · answered by unnga 6 · 0⤊ 2⤋