ControlFormat.SmallChange Property

Syntax

expression.SmallChange

expression A variable that represents a ControlFormat object.

Example

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

Visual Basic for Applications

Visual Basic for Applications
`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`

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

Change line scroll increment? Increase that amount scrolled on clicking next line arrow? small small change Small Change Property SmallChange smallchange property

Returns or sets the amount that the scroll bar or spinner is incremented or decremented for a line scroll (when the user clicks an arrow). Read/write Long.

See also: