HotXLS Docs

DashStyle property

Returns or sets the dash style for the specified line. Read/write Longword.

Syntax

property DashStyle: Longword;

Description

DashStyle can be one of these constants:
msoLineSolid
msoLineSquareDot
msoLineRoundDot
msoLineDash
msoLineLongDash
msoLineDashDot
msoLineLongDashDot
msoLineDashDotDot

Example

This example creates new comment on cell B2 with red dashed border

With Workbook.Sheets[1] do begin
  With Range['B2', 'B2'].AddComment('Comment text') do begin
    Shape.Line.Style := msoLineSingle;
    Shape.Line.DashStyle := msoLineDash;
    Shape.Line.Weight    := 0.25;
    Shape.Line.ForeColor.RGB := $0000FF;
  end;
end;