comment

[Sanjiv]

Hello, I want the comment made in sheet 1 & cell A1 , to appear elsewhere in
the same workbook but in sheet 2 where the cell value and the comment from
Sheet 1 & cell A1 is reffered again.

I hope its clear : Thanks.

 

[Shane Devenshire]

Hi,

If I understand you want to link two comments to each other?

If so, there is nothing built into comments to allow this. So here are some
of your options:

1. Use VBA and have the Sheet_Activate event trigger a routine that copies
the comment from the first sheet to the second.
2. You can manually copy the comment from one cell to another
3. You could put your comment's text in a autoshape, and then link both
autoshapes to a single cell in which you could type the comment text.

Cheers,
Shane Devenshire