Resource.Notes property (Project)

Gets or sets the notes for a resource. Read/write String.


expression. Notes

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 
 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.