| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 !!) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 !!) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 !!) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ask for email title/comments in working Mail Active Sheet code | Excel Programming | |||
| How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | Excel Programming | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| Active Workbook Properties - comments | Excel Programming | |||
| removing hard breaks from comments or active cells | Excel Programming | |||
Hybrid Mode
