Max, Min properties
Specify the maximum and minimum acceptable values for the Value property of a ScrollBar or SpinButton.
Syntax
object.Max [= Long ]
object.Min [= Long ]
The Max and Min property syntaxes have these parts:
| Part | Description |
|---|---|
| object | Required. A valid object. |
| Long | Optional. A numeric expression specifying the maximum or minimum Value property setting. |
Remarks
Clicking a SpinButton or moving the scroll box in a ScrollBar changes the Value property of the control.
The value for the Max property corresponds to the lowest position of a vertical ScrollBar or the rightmost position of a horizontal ScrollBar.
The value for the Min property corresponds to the highest position of a vertical ScrollBar or the leftmost position of a horizontal ScrollBar.
Any integer is an acceptable setting for this property. The recommended range of values is from -32,767 to +32,767. The default value is 1.
Note
Min and Max refer to locations, not to relative values, on the ScrollBar. That is, the value of Max could be less than the value of Min. If this is the case, moving toward the Max (bottom) position means decreasing Value; moving toward the Min (top) position means increasing Value.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.