Show me cell comments ONLY when cell is selected

[NYBoy]

Just a quick question.

Everytime mouse curser is on the cell the comments window appears.
have a lot of comments on a lot of cells.
I want excel to show me comments ONLY when I select on the cell.

Is it possible?

NYBo

 

[Dave Peterson]

One way is to use a worksheet event:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim myCell As Range
'turn off the comment indicator
Application.DisplayCommentIndicator = xlNoIndicator

For Each myCell In Target.Cells
If myCell.Comment Is Nothing Then
'do nothing
Else
myCell.Comment.Visible = True
End If
Next myCell
End Sub

Rightclick on the worksheet tab that should have this behavior and select view
code. Paste this in and try selecting different cells.

 

[NYBoy]

Thanks Dave.

You guys are amazing. I don't know how you do these codes but they
work.
I'm an aircraft engineer but I think you guys know all the secrets.

Thanks again,
NYBoy

 

[RagDyeR]

Another option, where there is *no* indication that a comment is even
present ... until the cell is selected ... is to use the
<Data> <Validation> <InPut Message> tab.

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


message
Thanks Dave.

You guys are amazing. I don't know how you do these codes but they
work.
I'm an aircraft engineer but I think you guys know all the secrets.

Thanks again,
NYBoy