1. T

    Refactor VBA for scrolling to the next colored cell (with different color than selected)

    Hi guys. I've found online a VBA made by p45cal which scrolls the view to the next colored cell in a selected column and it's working fine, but I would like to make some tweaks to it. Right now it is scrolling to the next colored cell as it should, but I would like to modify it to make it...
  2. M

    Excel Worksheet Allowing Scroll Beyond Data

    Hi all, My Excel365 has just started behaving strangely. I create many simple reports of data in a month and for some reason (shown in the example below) the report has 11 rows of data but the worksheet allows scrolling way beyond that, indicated with the arrow on the image showing the small...
  3. D

    Vertical Scroll Bar fake copy?

    So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...
  4. A

    Split Column but independent vertical scroll?

    Hello, I have 2 lists that i'd like to be able to compare in my spreadsheet. One is quite short (20 rows), and one is quite long(75 000 rows). To do this, I would like to split the spreadsheet into two parts with independent vertical scrolling. I have seen that using .SplitColumn I get the...
  5. E

    Macro to scroll page side to side

    I have a few buttons on my sheet where I have macros recorded to scroll the screen to a certain column, kind of like a jump to button. I have columns labeled 1 - 100, so I have buttons for "1", "15", "30", "45" and so on all the way though 90. Below are the macros I recorded, but instead of...
  6. D

    Scroll when inside "dropdown area" of combobox, not just main object - userform

    I have found much help in this forum but I'm lacking the last dot of the "i". I've come across 2 different approaches to getting mousewheel scroll inside a userform. Both written by @Jaafar Tribak These are: [Alt.1] – Scroll any control [Alt.2] – Scroll ListBoxes With [Alt.1] scrolling inside...
  7. B

    Can I Freeze a Slicer

    I have a date slicer connected to a pivot table with over 3000 rows so I was wondering if it was possible to freeze it like I can with an excel row? I have the top row of my sheet frozen so I can see the column headers while I scroll but my slicer moves out of view when I scroll. I thought it...
  8. sharky12345

    Scroll to last cell with date

    I have a series of dates in column E and I need to scroll to the last cell which has today as the current date. If it makes a difference, the cells are formatted as "dd/mm/yyyy" Anyone?
  9. M

    Hold or anchor cell content

    Hold or anchor cell content to scroll with cell Not sure if I am explaining it right but in the attached example you can see the milestone I added do not scroll with the sheet they stay on the page no matter how much I scroll. Any ideas on how I can add them and they scroll correctly
  10. sparky2205

    Issue scrolling on a spreadsheet

    Hi folks, I have a spreadsheet which I've been using successfully for months. I updated it this morning with some text. To achieve this I had to unprotect the spreadsheet and unfreeze panes. I made my changes, put freeze panes back on, protected it again and then saved it. Now when I try to...
  11. TAPS_MikeDion

    VBA 2011 for Mac (ver 14.0) - Screwed up userform scroll bars

    Hello everyone, Is there something I'm doing wrong with trying to add scroll bars to my userform? As per the title, I'm using VBA for Mac 2011 and I can't seem to get the scroll bars to work. I can only double-click them to get them to move. There aren't even arrows to click on. What the ...
  12. B

    scroll through dynamic 0-24 hour time format xvlaues

    i am working on dynamic chart showing hourly data (1-24 format) and i want to scroll tgrough data on specified time span like 5hour,there is times that .minimumscale is greater than .maximumscale property on chart (cht.chart.axes. ...)and scroll has problem( for example when time span is between...
  13. 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...
  14. T

    Finding & Selecting Date / Freeze Panes

    In cell H3 I have a list of dates from a drop down list / data validation. In column A there is a long list of dates starting in row 5 all the way down to row 838. Panes are frozen starting with row 5 so when you scroll, rows 1-4 are the only ones that stay (and don't scroll). What I want to...
  15. A

    Comment with scroll bar

    Can I create a comment template with a scroll bar using VBA which gets trigger through a command button
  16. D

    How to stop Frame Scroll Bar from jumping in vba

    Good day all, I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 columns. The 40 textboxes on the first column each have a list box. The problem is when I double click on the list box...
  17. A

    Scroll Left

    Application.Goto Reference:=Range("a1"), Scroll:=True I found this works, but can you not select the cell. Aim is to scroll to Home (left) in the Worksheet only. Thanks.
  18. C

    Scroll sheet to find value based on another cell.

    Hi All, Hoping someone can help me with this. I assume this will require VBA which i have little knowledge of, In the below example. I want to automatically scroll to and select the cell of the equivalent Week number as the user inserts into B3. So the result would be, M3 is now selected and...
  19. E

    Scroll Here

    In a sheet with about 6000 rows, I can scroll without any problem with the mouse wheel, as well as with Scroll Up and Scroll Down If I try to Scroll Here (clicking at about the middle of the bar to the right of the screen): - in Excel 2010, I go to the area around row 3300 :) - in Excel 2016...
  20. T

    how do i resetthe vba scroll bar to the top position?

    Hi everyone, I'd like a macro that resets the vba scroll bar to the top, I mean the actual bar in the scroll bar, I can do it manually within the properties under value but can't get the vba to set it. can this be done? Thanks Tony

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