DashStyle Property

Microsoft Excel Visual Basic

Show All

DashStyle Property

       

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

MsoLineDashStyle can be one of these MsoLineDashStyle constants.
msoLineDash
msoLineDashDot
msoLineDashDotDot
msoLineDashStyleMixed
msoLineDashLongDash
msoLineDashLongDashDot
msoLineRoundDot
msoLineSolid
msoLineSquareDot

expression.DashStyle

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

This example adds a blue dashed line to myDocument.

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