Description
Represents a scroll bar control on a chart, dialogsheet, or worksheet. Window scroll bars are not ScrollBar objects. ScrollBar objects do not support border or pattern formatting.
Accessors
The ScrollBar object is a member of the ScrollBars collection. The ScrollBars collection contains all the ScrollBar objects on a single sheet. Use the Add method to create a new scroll bar and add it to the collection. Set the width argument to be greater than the height argument to create a horizontal scroll bar.
To access a single member of the collection, use the ScrollBars method with the index number or name of the scroll bar as an argument. The following example sets scroll bar one on the dialog sheet named "Dialog1" to the top or left of its range.
DialogSheets("dialog1").ScrollBars(1).Value = 0
The scroll bar name is shown in the Name Box when the scroll bar is selected. Use the Name property to set or return the scroll bar name. The following example sets the OnAction property for the scroll bar named "Scroll Bar 6." The Visual Basic procedure named "ScrollProc" is called whenever the scroll bar changes.
DialogSheets(1).ScrollBars("scroll bar 6").OnAction = "ScrollProc"
Properties
Application Property, BottomRightCell Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, Index Property, LargeChange Property, Left Property, LinkedCell Property, Locked Property, Max Property, Min Property, Name Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, SmallChange Property, Top Property, TopLeftCell Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method.