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. Unhide formula bar via Excel Options. An alternative way to restore a lost formula bar in Excel is this: Click File (or the Office button in earlier Excel versions). Go to Options. Click Advanced in the left pane. Scroll down to the Display section and select the Show Formula bar option.

  1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Discussion in 'Business Applications' started by alexfooty, Apr 25, 2007.

Thread Status:
Not open for further replies.

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!

Thread Status:
Not open for further replies.
Excel

Short URL to this thread: https://techguy.org/566543 I inc ah191d driver for mac.

2010

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:

  1. While your form is unprotected, click the Scroll Bar control on the Developer Ribbon.

  2. Drag diagonally and then let go of the mouse.

    A scroll bar appears as selected on your worksheet.

  3. Right-click the new scroll bar and choose Format Control from the pop-up menu.

    The Format Control dialog displays.

  4. 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.

  5. 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.

  6. 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.