Weight Property

Microsoft Excel Visual Basic

Show All

Weight Property

       

 Weight property as it applies to the LineFormat object.

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

expression.Weight

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

 

Weight 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