Comments changes as active cells changes


S

Sugar Land

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

Advertisements

S

Sugar Land

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

Thanks in advance, Matt
 
Ad

Advertisements

J

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

Top