Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Comment Box
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comment Edit | Excel Worksheet Functions | |||
Edit Comment problem | Excel Discussion (Misc queries) | |||
VBA to edit a comment | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
cannot edit comment | Excel Discussion (Misc queries) |