Application.DefaultDurationUnits property (Visio)

Determines the default unit of measure for quantities that represent durations. Read/write.

Syntax

expression.DefaultDurationUnits

expression A variable that represents an Application object.

Return value

Variant

Remarks

The DefaultDurationUnits property corresponds to the value shown in the Duration box under Display on the Advanced tab of the Visio Options dialog box (File tab > Options).

The return value contains one of the values of VisUnitCodes, which are declared in the Microsoft Visio type library.

You can specify DefaultDurationUnits as an integer (a member of VisUnitCodes) or a string value such as "minutes". If the string is invalid or the unit code is inappropriate (non-duration), an error is generated.

For a complete list of valid unit strings along with corresponding Automation constants (integer values), see About units of measure.

Cell formulas that contain a specific unit of measure are displayed in those units regardless of the default duration units setting. Many cell formulas, however, use implicit unit syntax and are displayed in default units.

A program can create a cell whose formula displays in default units by setting the cell's Formula property to a string in implicit unit syntax. For example, if a formula specifying duration is "=10[em,E]", the result displays as "0.0069 ed" if the DefaultDurationUnits property is visElapsedDay, and as "600.0000 es" if the DefaultDurationUnits property is visElapsedSec.

Alternatively, a program can use the following statement to set the cell's result to default duration units.

vsoCell.Result(visDurationUnits) = 60

In this case, the result is 60 minutes if the DefaultDurationUnits property is visElapsedMin and 60 seconds if the DefaultDurationUnits property is visElapsedSec.

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.