scroll

  1. 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...
  2. 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?
  3. 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
  4. S

    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...
  5. 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 ...
  6. 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...
  7. 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...
  8. 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...
  9. A

    Comment with scroll bar

    Can I create a comment template with a scroll bar using VBA which gets trigger through a command button
  10. 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...
  11. 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.
  12. 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...
  13. 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...
  14. 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
  15. T

    VBA to move the vba scroll bar up and down the page as rows are hidden

    Hi everyone, not sure if this can be done but what I need is this. I have a sheet with 800 rows I have a scroll bar and I need to move it to the right position on the page. so I need a macro that can count 100 rows from the top and move the scroll bar so the top of the bar is in row 100...
  16. T

    Link a VBA scroll bar to a sheet and have it move data up and down a column?

    Hi Everyone, I want to set up a VBa scroll bar to move a value up and down rows in a column? In Column Y I have the word "Start" now lets say its in cell Y25 I'd like to have a VBA scroll bar next to it and as I scroll up and down have the word "Start" move up and down the Column. can this be...
  17. M

    ComboBox - Cannot select combo box options

    I have a combo box that has a ListFilledRange property value of a particular column in my spread sheet. My code is fairly simple after this... Private Sub ComboBox1_Change() Me.ComboBox1.DropDown End Sub Can anyone tell me why when I click on a combo box selection from the scroll down...
  18. G

    Selecting different cell to what I click

    Hi, I've made a workbook on 1 PC using Office 365 2016, and now when I open the workbook on my laptop (SurfaceBook) I am getting a really strange issue. When I am clicking a cell it is selecting a different cell to what I click. It is not a mouse issue. For example clicking cell A48 is...
  19. Y

    Mouse Scroll wheel for frame scroll bar

    I need a code for mouse wheel to scroll the scrollbar on a frame. Note: the userform itself is modeless.
  20. K

    VBA: Command Button Always at Bottom Right of Form

    Hi I have created a dynamic form which will vary in height depending on user selection I have added a scroll bar so the user can scroll up and down the form i would like to add a Command button that would always be at the bottom right of form , is there a VBA code which can do this ? Thanks...

Some videos you may like

This Week's Hot Topics

Top