Copy cell contents in the form of comment in another sheet

[rmalik]

Dear All,

I am working on excel 2010

Query 1
I need to copy a cell content to a Comment into another worksheet.

sheet1
A1 = apple
A2 = orange

Sheet2 - target
A1 = comment (apple)
A2 = comment (orange)

Also, when I make changes in worksheet 1 it should automatically refect in
the comments in worksheet 2.

Query 2

Also, I want to change the display of the comment boxes so that they appear only when I hover my cursor over the respective cell.

Thanks in advance !

 

[hippiehacker]

query 1

you can use the following Worksheet_change event to write the comment on Sheet2 from the cell you change on sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Sheet2").Range(Target.Address).ClearComments
Sheets("Sheet2").Range(Target.Address).AddComment Target.Value
End Sub

query 2

Application.DisplayCommentIndicator = xlCommentIndicatorOnly