View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default Edit Comment Box

One way :

Sub ModifyComment()
Dim strS
strS = ActiveCell.Comment.Text
ActiveCell.ClearComments
ActiveCell.AddComment Text:=strS & "Your addition to comment."
End Sub

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Hello!

If I have a cell with a comment in it, what code would I use to add
more comments to the current comments? The comments I will be added
will be hard coded, nothing that the user would enter.

I am using the .offset command for the appropriate cell.

Thank you very much in advance,
E2L