SCROLLBAR.PROPERTIES macro

Sets the properties of the scroll bar and spinner button on a worksheet or dialog sheet.

Syntax

SCROLLBAR.PROPERTIES(value, min, max, inc, page, link, 3d_shading)

SCROLLBAR.PROPERTIES?(value, min, max, inc, page, link, 3d_shading)

Value    is the value of the control, and can range from min to max, inclusive. It designates where the scroll bar button is positioned along the scroll bar.

Min    is a number specifying the minimum value that the scroll bar can have. This number ranges from 0 to 30,000, but cannot be greater than the maximum value given in max.

Max    is a number specifying the maximum value that the scroll bar can have. This number ranges from 0 to 30,000.

Inc    is a number specifying the increment that the value is adjusted by when the scrollbar arrow is clicked.

Page    is a number specifying the increment that the value is adjusted by when the page scroll region of a scroll bar is clicked.

Link    is the cell on the macro sheet to which the scroll bar value is linked. Whenever the scroll bar control is changed, the value of the control is entered into the cell. Similarly, whenever the value in the cell is changed, the setting for the scroll bar is also changed. To clear the link, set this value to an empty string.

3d_shading    is a logical value that specifies whether the scroll bar or spinner button appears as 3-D. If TRUE, the scroll bar or spinner button will appear as 3-D. If FALSE or omitted, the scroll bar or spinner button will not be 3-D. The argument is available for only worksheets.

Related Functions

PUSHBUTTON.PROPERTIES   Sets the properties of the push button control

EDITBOX.PROPERTIES   Sets the properties of an edit box on a worksheet or dialog sheet

Return to index