Cell Comments - hiding the comment 
Author Message
 Cell Comments - hiding the comment

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



Tue, 20 Sep 2005 03:11:38 GMT  
 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


Tue, 20 Sep 2005 05:46:50 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Move Comment Box Flag And Comment Display To Left Side Of Cell

2. How Keep Comments Close To Commented Cells?

3. Getting Comments out of Comment Field

4. A comment that is not a comment???

5. Outlook 2002 Field Chooser All Document Fields Comments can't insert the comment

6. Comment one field while you update another with the same comments

7. Printing Comments in Word 2003 without Comment Reference Marks

8. comments in comments

9. Overlapping comments block "Next Comment"

10. blue comments - red comments?


 
Powered by phpBB® Forum Software © phpBB Group