Show me cell comments ONLY when cell is selected

  • Thread starter Thread starter NYBoy
  • Start date Start date
N

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
 
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.
 
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
 
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
 
Back
Top