Cell Comments
 

Is there a way to show a comment only when the corresponding cell is selected?

Cell Comments
 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim C As Comment

For Each C In ActiveSheet.Comments
C.Visible = (C.Parent.Address = Target.Address)
Next C

End Sub


"LDanix" wrote:

Is there a way to show a comment only when the corresponding cell is selected?

Cell Comments
 

Not a comment I don't believe (I assume you are unhappy with the default
behavior), but perhaps you could use data validation. It has several
options for popping up messages.

--
Regards,
Tom Ogilvy

"LDanix" wrote in message
...
Is there a way to show a comment only when the corresponding cell is
selected?