popup comment

[workshop]

Is there the way in excel file when I move a mouse over the cell then the comment popup but the list is in other worksheet? for example in the worksheet A when I move the mouse over cell a1 then the comment from worksheet B cell a1 popup.

Thanks for your helps

 

[newbiewonkinobie]

Can you do a copy then paste special > paste comments or does it have to be dynamic and change if the comments on worksheet B change?

Flores

 

[luceze]

As far as I know there is no mouseover event so there is not a way to show a comment from another workbook without using VBA. I think NewbieWon's suggestion will be the easiest way (Once again if the comment text doesn't have to be dynamic)
This piece of code will insert a comment into the activecell on sheet1 using the text from the comment in the corresponding cell of sheet2. However, I am not sure how to trigger the event.

Sub InsertComment()

On Error GoTo ErrorX
addx = ActiveCell.Address
ActiveCell.AddComment Sheets("Sheet2&quot.Range(addx).Comment.Text
ActiveCell.Comment.Visible = True
Exit Sub
ErrorX:
MsgBox "No comment"

End Sub

Mabye someone else has a better solution.

HTH,
Eric