Comments changes as active cells changes
 

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

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 !!)

Comments changes as active cells changes
 

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

Thanks in advance, Matt

"Sugar Land" wrote:

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

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 !!)

Comments changes as active cells changes
 

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
---------------
Jacob Skaria


"Sugar Land" wrote:

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

Thanks in advance, Matt

"Sugar Land" wrote:

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

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 !!)