Comments changes as active cells changes


Sugar Land

I have an Excel spread sheet with thousands of lines with comments on every

When the cursor is on the cell (example: C3), I can see the comments. When
I return to the next line (C4) using “enter†or “down arrowâ€, I wish I could
see the comment for the next cell. The comment stays there and I have to use
the mouse to see the comments for the cell (C4).

Is there something I can do in Excel to activate that function? Or even a
macro (experts, need your help !!)

Sugar Land

additional info: The comments are big and "display all" is not helpful.

Thanks in advance, Matt

Jacob Skaria

Right click the sheet tab and View Code..In the code pane paste the below
code..and try in that sheet...

'Display comments on cell selection
Dim rngTemp As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not rngTemp Is Nothing Then rngTemp.Comment.Visible = False
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
Set rngTemp = Target
End If
End Sub

If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question