Muokkaa

Jaa

Scenario.Comment property (Excel)

  • Artikkeli

Returns or sets a String value that represents the comment associated with the scenario.

Syntax

expression.Comment

expression A variable that represents a Scenario object.

Remarks

The comment text cannot exceed 255 characters.

Example

This example sets the comment for scenario one on Sheet1.

Worksheets("Sheet1").Scenarios(1).Comment = _ 
 "Worst case July 1993 sales"

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.