| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
| Question: Is it possible to link a cell to a comment box window? | Excel Discussion (Misc queries) | |||
| adding a hyper link to a cell comment | Excel Discussion (Misc queries) | |||
| Excel, in a cell, how do i link to a pic & autohide like a comment | Excel Discussion (Misc queries) | |||
| How do I insert in a cell a link to display a JPG file in window | Setting up and Configuration of Excel | |||
Linear Mode
