User Name Value

[MikeG]

In Excel, when someone adds a comment to a cell, then Excel starts the comment with the name of the user, followed by a ":"

Does anyone know how I can read that name into a variable so that I can use it in VBA? I guess it is based on the User Account name.

Thanks,

Mike

 

[dave3009]

You could use the Author from the content, like so

Sub getCommentName()
Dim commentContent As String
commentContent = Range("A1").Comment.Author
MsgBox commentContent
End Sub

 

[Kenneth Hobson]

For the current user:

MsgBox Application.Username

 

[mikerickson]

I believe that this is where Excel finds the user name to add to comments

MsgBox ThisWorkbook.BuiltInDocumentProperties("Author").Value

 

[MikeG]

Thanks folks.

I now have the username value in my macro.

MikeG

 

[Kenneth Hobson]

When I changed the Application.Username, new comments used that but ThisWorkbook.BuiltInDocumentProperties("Author").Value showed the previous value.

 

[mikerickson]

Kenneth, thanks for checking. It's good to know where Excel get's its values.