Excel notes/comments not appearing

Murray Brown
Murray Brown used Ask the Experts™

When I hover over a cell with a comment I see the following. What would cause this?1
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Group Finance Manager
Could the comment have been accidentally reduced in size?

Try running this code

Option Explicit

Sub CheckComments()
    Dim rCl As Range
    On Error Resume Next
    For Each rCl In Cells.SpecialCells(xlCellTypeComments)
        With rCl.Comment
            .Visible = True
            .Shape.TextFrame.AutoSize = True
        End With
    Next rCl
    On Error GoTo 0
End Sub

Open in new window

Rob HensonFinance Analyst
I have been able to replicate the issue by shrinking a comment to zero width.

If you don't want to use Roy's VBA suggestion above, right click on cell, and select Edit Comment then right click on the comment and select Format Comment. Use the Width box to expand the comment. Or, while the note is selected use the grab handles to drag the size out.
Kesavan JeganarayananIT Consultant

Go to File | Options | Advanced in you Excel program.

- From the Display section Select the option Indicators only, and comments on hover
- Click on Ok
Murray BrownASP.net/VBA/VSTO Developer


thanks for the help
Roy CoxGroup Finance Manager

Pleased to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial