Weight Property [Excel 2003 VBA Language Reference]
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.
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
Applies to | Border Object | Borders Collection | LineFormat Object