Share via

Max Property [Excel 2003 VBA Language Reference]

  • Article

Returns or sets the maximum value of a scroll bar or spinner range. The scroll bar or spinner won't take on values greater than this maximum value. Read/write Long.

For information about using the Max worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic .

Remarks

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

Example

This example creates a scroll bar and sets its linked cell, minimum, maximum, large change, and small change values.

Set sb = Worksheets(1).Shapes.AddFormControl(xlScrollBar, _
    Left:=10, Top:=10, Width:=10, Height:=200)
With sb.ControlFormat
    .LinkedCell = "D1"
    .Max = 100
    .Min = 0
    .LargeChange = 10
    .SmallChange = 2
End With

Applies to | ControlFormat Object

See Also | Min Property