Office 2011 for Mac: Making a Scroll Bar for Excel Forms
9 of 12 in Series: The Essentials of Making Forms in Office 2011 for Mac
A scroll bar control in a form made in Excel 2011 for Mac generates a number within a specified range, in set increments. The form user drags the scroll bar control left and right or up and down. As the user drags the control, the number increases or decreases. The form user can adjust the scroll bar using the arrows at the right or bottom end, and you can click into the bar to change the control in specified increments.
You can use scroll bars in a variety of ways. To make a scroll bar on a worksheet, take these steps:
While your form is unprotected, click the Scroll Bar control on the Developer Ribbon.
Drag diagonally and then let go of the mouse.
A scroll bar appears as selected on your worksheet.
Right-click the new scroll bar and choose Format Control from the pop-up menu.
The Format Control dialog displays.
On the Control tab of the Format Control dialog, set a cell link by clicking into the empty Cell Link field and then clicking a cell on any worksheet.
The linked cell is indicated in the Cell Link field in the dialog. This is where the results of the form user’s selection will display.
On the Control tab of the Format Control dialog, use spinner controls to adjust the following settings as desired:
(Optional) Current Value: Set a default value. Displays the scroll bar’s current value if it has been changed on the form.
Minimum Value: The number in the linked cell when the scroll bar is all the way to the left.
Maximum Value: The number in the linked cell when the scroll bar is all the way to the right.
Incremental Change: The incremental number for how much the number increases or decreases as the scroll bar is moved.
Page Change: How much the value will change when a user clicks into the scroll bar itself, but not on the scrollbar's drag button.
Click OK to close the Format Control dialog.
Click the Lock Cells button to unlock the linked cell. The control won't work when you protect the worksheet unless you unlock the linked cell.