Cell Comments - hiding the comment
You could use the Selection_Change event to show/hide the comments. For
example:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
If Target.Comment Is Nothing Then
Exit Sub
Else
Target.Comment.Visible = True
End If
End Sub
Quote:
> I have code in the Workbook_sheetChange event that will
> make the comment 'bubble' appear when the user populates
> the cell. The user wants the comment to go away when they
> are done typing. This would seem to be easy but for the
> fact that when I add code to set the comment.visible =
> false, the comment 'bubble' appears and disappears so
> quickly that it is never seen. Does anyone have some
> suggestions for a sequnce of events to pursue to make the
> comemnt bubble stay up until the user is done typing?
> thanks you
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html