LineFormat.DashStyle Property

Excel Developer Reference

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



expression   A variable that represents a LineFormat object.


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