Edit

Share via

Resource.Notes property (Project)

  • Article

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

Syntax

expression. Notes

expression A variable that represents a Resource object.

Remarks

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.

Example

The following example adds a comment to the notes of the resource in the active cell.

Note

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.