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

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?

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

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

"Kent" wrote:

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?

Question: Is it possible to link a cell to a comment box windo
 

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" wrote:

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

"Kent" wrote:

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?

Question: Is it possible to link a cell to a comment box windo
 

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

"FSt1" wrote:

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" wrote:

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

"Kent" wrote:

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?