Max Property

Applies To

DrawingObjects Collection, ScrollBar Object, ScrollBars Collection, Spinner Object, Spinners Collection.

Description

Returns or sets the maximum value of a scroll bar or spinner range. The scroll bar or spinner will not take on values above this maximum value. Read-write.

For help about using the Max worksheet function in Visual Basic, see "Using Worksheet Functions in Visual Basic" in online Help.

Remarks

The value of the Max property must be greater than the value of the Min property.

See Also

Min Property.

Example

This example sets the minimum and maximum values for scroll bar one on Dialog1.

With DialogSheets("Dialog1").ScrollBars(1)
    .Min = 20
    .Max = 50
End With