Comment Boxes

[Ann]

I have a comment box in a cell - the comment is quite
large but when I drag the comment so that I can see all
the text, it returns to original position and I cannot see
all of the comment. Is it possible to change the position
of the comment?? so that when I position the cursor over
the cell it will show above rather than below??

Thanks

Ann

 

[Ann]

Thanks Debra
Can this be changed in any way - maybe with code??

Ann

 

[Debra Dalgleish]

You can't change the default popup position of the comment, either
manually, or programmatically. You could create a macro that makes a
comment visible when you select a cell, and it would appear in the
position where you placed it, instead of the default popup position. You
could hide the comment when you selected a different cell. For example:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
'ActiveSheet.Comments.Visible = False
Application.DisplayCommentIndicator _
= xlCommentIndicatorOnly
If Not Target.Comment Is Nothing Then
Target.Comment.Visible = True
End If
End Sub

However, if the user points to the cell, then selects it, the comment
will appear in the default position, and that will reset the comment's
visible position.