Scroll Bar control

The ScrollBar control is similar to a SpinButton control (described later). The difference is that the user can drag the ScrollBar's button to change the control's value in larger increments. Figure 17-14 shows a ScrollBar control. Its Value is displayed in a Label control.

Figure 17-14:

A ScrollBar control, with a Label control below it.

Figure 17-14:

A ScrollBar control, with a Label control below it.

How Link Vba Scrollbar Label

The following is a description of the most useful properties of a ScrollBar control:

1 Value: The control's current value. 1 Min: The control's minimum value. 1 Max: The control's maximum value.

1 ControlSource: The worksheet cell that displays the control's value.

1 SmallChange: The amount that the control's value is changed by a click.

1 LargeChange: The amount that the control's value is changed by clicking either side of the button.

The ScrollBar control is most useful for specifying a value that extends across a wide range of possible values.

0 0

Responses

  • simon
    How to link vba scrollbar to label?
    7 years ago

Post a comment