LineFormat.DashStyle Property

  • Article
Excel Developer Reference

Returns or sets the dash style for the specified line. Can be one of the MsoLineDashStyle contants. Read/write Long.

Syntax

expression.DashStyle

expression   A variable that represents a LineFormat object.

Example

This example adds a blue dashed line to myDocument.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes.AddLine(10, 10, 250, 250).Line
    .DashStyle = msoLineDashDotDot
    .ForeColor.RGB = RGB(50, 0, 128)
End With

See Also