Resource.Notes property (Project)
Gets or sets the notes for a resource. Read/write String.
expression A variable that represents a Resource object.
The Notes property does not accept characters with an ASCII value less than 32, except for the carriage return (ASCII 13) and linefeed (ASCII 10) characters.
The following example adds a comment to the notes of the resource in the active cell.
If a resource is not selected, the code results in a run-time error 1004.
Sub AddStatusNote() Dim noStatus As String noStatus = "No status report yet." If ActiveCell.Resource.Notes = "" Then ActiveCell.Resource.Notes = noStatus Else ActiveCell.Resource.Notes = ActiveCell.Resource.Notes _ & vbCrLf & vbCrLf & noStatus End If End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.