Get comments into a cell from the track changes comments

[tplee]

Hi all,

New to the forum. I have a quick question hopefully someone can help me with.

So I found this neat VBA code online to extract the comments from a comment into a cell by using =getcomment() formula.

here is the code I used:

Function GetComments(rngTemp As Range)
If Not rngTemp.Comment Is Nothing Then
GetComments = rngTemp.Comment.Text
End If
End Function

This actually works beautifully but I have one problem. It will only get the comments out of a manually created comment. What I would like it to do is have it give me the comments from a shared Track Changes comment. The comment that show up in a black box around a cell whenever anything is changed.

Does anybody know of a way to do this?

Basically what I'm trying to do is get the username of whoever makes a change to a certain cell and place it in another cell.

If there is a better way to do this that works as well.

Appreciate the help in advance.

Thanks,