Min and Max Properties are integer values (Long variable) which specify the minimum and maximum acceptable values of the ScrollBar control (for the Value property setting).

The default value is 1 for both the properties. The LargeChange Property specifies the incremental change when the user clicks between a scroll arrow and the scroll box. SmallChange Property specifies the incremental change, as an integer value (Long variable), that occurs when a user clicks the scroll arrow. ScrollBar & SpinButton controls - the difference between the two is that the ScrollBar box can be dragged to change the control's value over larger increments (while keeping the increment low for clicks) which advantages a ScrollBar to make a selection from across a large number of values and cover an extremely wide range. It scrolls through a range of values when a user: (i) clicks on the scroll arrows (ii) drags the scroll box or (iii) clicks in an area between a scroll arrow and the scroll box. TextBox, Label, …) or the value in a worksheet range.

Note: In below given examples, vba codes are required to be entered in the Code Module of the UserForm, unless specified otherwise.Ī ScrollBar control enables to change (increment or decrement) the value displayed by other UserForm controls (viz. UserForm and Controls - Properties ' for properties common to the UserForm and most Controls Using ActiveX Controls on a Worksheet have been illustrated in detail, in the separate section of ' Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet'.Īlso refer ' 2. By itself, a UserForm will not be of much use unless ActiveX controls are added to it which are the actual user-interactive objects. UserForm acts as a container in which you add multiple ActiveX controls, each of which has a specific use and associated properties. UserForm Controls - ScrollBar and SpinButton

Excel scroll bar in cell