scroll bars

  1. D

    Access 2010: Scroll Bars - again

    I have a form with a header section (containing controls) and the detail section which returns the result of a Search - determined by what is input in the control(s). If I have the vertical scroll bar showing, it extends into both the header and the detail part of the form. Since the...
  2. M

    Userform Scroll Bars

    Hi. I have looked for a thread that would solve the problem I am having but with no luck. I have created a Userform that will be used on a number of different PC's and laptops. The form itself seems to be working fine but on some screens the form does not fit and users cannot move the form...
  3. X

    VBA Scroll macro run after another macro??

    Hey Mr.Excel I'm working with a Excel document containing a good portion of scroll bars. I have a macro that i run to update my data, and after the macro is finished I have to manually move all scroll bars. Therefore would hear if there was a way to get the scroll bars two move 1 value/date...
  4. D

    Move 3 Columns using ActiveX Scroll Bar Function

    Hi, Could someone let me know how to move three columns using ActiveX scroll bar. If I click right side end of scroll bar by having the selection in A1, then selection should go to the cell E1. From E1 if I click the left side endof scroll bar, then the selection should come back to the cell...
  5. G

    How to hide formulas in excel without loosing the functionality of scroll bar

    I want to create a dynamic dashboard with drop-downs and scroll bars. I want to hide my formulas but I want my scroll bars and drop-downs to be functional. I tried protecting sheet but it is not helping me out Please suggest me how to do it.
  6. G

    A Fast Way To Add Multiple Text boxes With Scrollbars and Add Original ID?

    Hi All, I have hit a bit of an issue when creating a system that keeps track of issues coming into an inbox (it’s kind of like a database of issues). Because the cells will contain so much data I have had to insert textboxes that have scrollbars to see all the data (they are linked to the cell...
  7. B

    Vertical Scroll Bar Jumps from top to bottom of file instead of bottom of data

    Using Excel 2010 on Windows 7. This problem is driving me crazy. I have data (formulas) in a worksheet from row 1 to 1000. However, the scroll bar thinks there is data to the bottom of the worksheet, the very bottom!!! So the scroll bar is very small and if you move it even a fraction, you jump...
  8. P

    Scroll bars capturing all rows and columns

    Hi, just a quick question relating to the scroll bars capturing all the cells. In the situation where I format a row or a column with a command that captures the whole row or column (e.g. highlighting a column with a certain colour) or a mistake entry of a value at the end of a row. This can...
  9. N

    VBA to resize multiple Chart Series via A Scrollbar.

    Hello, I currently have a beautiful bit of code assigned to a scrollbar, that was suggested to me here on Mr.Excel. Thanks to all the Gurus out their for their continual support and assistance. Sub Scrollbar1_Change() Select Case ActiveSheet.ScrollBars("Scroll bar 3").Value Case "0" Call...
  10. C

    how to use a scrollbar to select values instantly

    Hi, Is there any way a user can select a spot on the scrollbar and the bar moves there instantly? I have my scrollbar in place so that the user can answer a question to choose between a digit 0 and 21 (the value goes to cell A1). However you have to click multiple times to get the scrollbar to...
  11. repairman615

    Scroll with a scroll bar???

    Hello, This is something I have been working on for days...It seems simple enough. I would like to add a scroll bar that will scroll a range, independantly of the main horizontal scroll bar. The range is a table from f10:ce25. Thanks in advance...
  12. L

    Userform has mind of its own

    Hi. I have a userform with both vertical and horizontal scroll bars on it. When the form opens, the scroll bars are in their upper-most and left-most positions, which is where I want them to be. But when I click on a combo box in the upper left corner to begin filling out the form, it...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top