title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
ControlFormat.SmallChange property (Excel) |
vbaxl10.chm630089 |
|
|
5c2c668a-3d4d-ac01-e08b-0db6278ddffd |
04/23/2019 |
medium |
Returns or sets the amount that the scroll bar or spinner is incremented or decremented for a line scroll (when the user chooses an arrow). Read/write Long.
expression.SmallChange
expression A variable that represents a ControlFormat object.
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
[!includeSupport and feedback]