Thread: VB Code for Comments

Two questions. First, I have one sheet that has account information in it with comments, and on the other sheet, I was wanting to copy the comments over. I found the following code that would work as a function to copy comments over, but I can't seem to make it work from sheet to sheet, only within the sheet I am working on:

Function getComment(incell) As String
' aceepts a cell as input and returns its comments (if any) back as a string
On Error Resume Next
getComment = incell.Comment.Text
End Function

Any ideas on this one?


Second, I was wondering if there was a way to extract the comments without displaying the username. Now the part that gets tricky is, I want the username to display of who input the comment BUT when I am extracting the comment using the function I do not want it to copy over the username that input the comment.

Any help will be GREATLY appreciated!!!

Hello jo15765,


To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code using the # icon

1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

To manually wrap your code, use these Bulletin Board Code Tags

[code] Before of the first line,

[/code] After the last line.