Description
A collection of all the ScrollBar objects on the specified chart sheet, dialog sheet, or worksheet (not including window scroll bars). ScrollBar objects do not support border or pattern formatting.
Accessors
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. The following example adds a new scroll bar to the dialog sheet named "Dialog1." The new scroll bar is positioned relative to the upper-left corner of the dialog frame.
Dim df As DialogFrame
Set df = DialogSheets("dialog1").DialogFrame
DialogSheets("dialog1").ScrollBars.Add df.Left + 10, _
df.Top + 20, 10, 100
Use the ScrollBars method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example sets each of the scroll bars on the worksheet named "Sheet1" to the top or left of its range.
Properties
Application Property, Count Property, Creator Property, Display3DShading Property, Enabled Property, Height Property, LargeChange Property, Left Property, LinkedCell Property, Locked Property, Max Property, Min Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, SmallChange Property, Top Property, Value Property, Visible Property, Width Property, ZOrder Property.
Methods
Add Method (Graphic Objects and Controls), BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.