ControlFormat.LargeChange Property

Syntax

expression.LargeChange

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 the size of jump when using scroll bar? large large change Large Change Property LargeChange LargeChange Property Set the amount of scroll for next page?

Returns or sets the amount that the scroll box increments or decrements for a page scroll (when the user clicks in the scroll bar body region). Read/write Long.

See also: