ScrollBars Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single scroll bar control (a ScrollBar object, Syntax 1) or a collection of scroll bar controls (a ScrollBars object, Syntax 2) on the sheet.

Syntax 1

object.ScrollBars(index)

Syntax 2

object.ScrollBars

object

Required. The Chart, DialogSheet, or Worksheet object.

index

Required for Syntax 1. Specifies the name or number of the scroll bar (can be an array to specify more than one).

See Also

Max Property, Min Property.

Example

This example sets the minimum and maximum values for scroll bar one on Dialog1.

With DialogSheets("Dialog1").ScrollBars(1)
    .Min = 20
    .Max = 50
End With