Let us take an example, in a scroll bar which has minimum value 0 and maximum value 10, if the user puts 2 in Page change property, the value of the scrollbar will increase or decrease by 2 (in the same case, 20% of the value range of the scroll bar) when you click the area between the scroll bar and any of the scroll arrows. Page Change: Provide the amount in Page change that the value increases or decreases and the degree to which the scroll bar moves if you click between the scroll box and any end arrow of a scrollbar.If this is set to 1, if you click the down arrow of the scrollbar, its current value will increase by 1.
Incremental Change: This defines the number of values to be changed in one click movement of the scrollbar.The current value will always lie between the Minimum and Maximum Value. Maximum Value: This defines the maximum value possible of the scrollbar.Minimum Value: This defines the minimum position value of the scrollbar.Basically, it will define the current position of the scrollbar.
The current Value field defines the current value of the scrollbar.
You can download this Scrollbar Excel Template here – Scrollbar Excel Templateįirst, you need to enable the Developer tab visible on the ribbon so you can get to the VBA and the ActiveX control commands.