Cell Comments-Is there a way to show a comment only when the corresponding cell

[LDanix]

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

[Tom Ogilvy]

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" <LDanix@discussions.microsoft.com> wrote in message
news:17115113-6BA3-4DED-B8E8-C50D2DCF2916@microsoft.com...
> Is there a way to show a comment only when the corresponding cell is
selected?

[K Dales]

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?