Excel.ControlFormat.LargeChange.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ControlFormat.LargeChange property (Excel)	vbaxl10.chm630078	vbaxl10.chm630078	Excel.ControlFormat.LargeChange	2e47bd4f-59dc-d620-14f0-e4ecdfb4eb78	04/23/2019	medium

ControlFormat.LargeChange property (Excel)

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.

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.

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]