Edit Comment Box

  • Thread starter Thread starter Eager2Learn
  • Start date Start date
E

Eager2Learn

Hello!

If I have a cell with a comment in it, what code would I use to ad
more comments to the current comments? The comments I will be adde
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,
E2
 
One way :

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

HTH
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If ActiveCell has a comment then exit sub 22
Code to add comments to selected cells within a selected range 30
Copy to a mid column range Row 10 - Row 20 4
Excel Import Comments 3
Can't Edit my Excel Comments 10
Word to Excel: Export comments with text and line number 0
Comments Boxes 6
Comment Box Placement 1

Back
Top