Question: Is it possible to link a cell to a comment box window?

[Kent]

Hello,

I have inserted a comment box on a cell and I want the comment to include
information from another cell.

So for example in the comment box it may say "Average is based on 3
employees" where the number three is linked to a cell on a different sheet.
So if the employee count changes to 23, the comment will change accordingly.

is this possible in a comment box?

 

[Kent]

Sorry for the double post, I did not see how to delete the first one

 

[FSt1]

hi
a comment doesn't work like a cell but you can change the comment programicly.
you might be able to tie it to the worksheet change event.
see debra's site on programing a comment
http://www.contextures.com/xlcomments03.html
lot of good stuff here.
regards
FSt1

 

[Kent]

Thank you for the link, I'll look into it

hi
a comment doesn't work like a cell but you can change the comment programicly.
you might be able to tie it to the worksheet change event.
see debra's site on programing a comment
http://www.contextures.com/xlcomments03.html
lot of good stuff here.
regards
FSt1