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...
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...
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...
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...
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...
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
[Alt.1] – Scroll any control
[Alt.2] – Scroll ListBoxes
With [Alt.1] scrolling inside...
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...
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
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...
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 ...
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...
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...
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...
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...
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...
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...
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?