Class Author (Excel VBA)

The class Author represents the author of the CommentThreaded object.

Item

To use a Author class variable it first needs to be instantiated, for example

Dim ath as Author
Set ath = ActiveCell.AddCommentThreaded.Author

Author class variables can be set using the CommentThreaded.Author procedure.

Name

Returns a String that contains the display name of the specified comment author.

Dim strName As String
strName = ActiveCell.AddCommentThreaded.Author.Name

ProviderID

Returns a String that represents the ID of the service providing the contact information.

Dim strProviderID As String
strProviderID = ActiveCell.AddCommentThreaded.Author.ProviderID

UserID

Returns a String that represents the user ID of the contact.

Dim strUserID As String
strUserID = ActiveCell.AddCommentThreaded.Author.UserID