Class Author (Excel VBA)

The class Author represents the author of the CommentThreaded object.


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.


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

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


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

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


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

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