Weight Property

Microsoft Excel Visual Basic

Returns or sets the weight of the line. Read/write Single.

expression.Weight

expression    Required. An expression that returns one of the above objects.

ShowWeight property as it applies to the Border and Borders objects.

Returns or sets the weight of the border. Read/write XlBorderWeight.

XlBorderWeight can be one of these XlBorderWeight constants.
xlHairline
xlThin
xlMedium

xlThick

expression.Weight

expression    Required. An expression that returns one of the objects.

Example

This example sets the border weight for oval one on Sheet1.

Worksheets("Sheet1").Ovals(1).Border.Weight = xlMedium