scroll bar

  1. G

    Formula or VBA for a Scroll bar to match min and max values of a variable cell?

    Hi everyone, In a table i have : E1= Apple; F1= 0.2%; G1= 1.5% E2= Banana; F2= 1.5%; G2= 3% E3= Pear; F3= 1%; G3= 4% E4= Cherry; F4= 4% ; G4= 10% E5= Peach; F5= 5% ; G5= 20% Column F represents the minimum % and column G represents maximum % In A1 i have a data validation drop down list...
  2. S

    Auto Scroll the Graph in Excel

    Hi everyone, I'm trying to make a graph on the base of data which I get from a external source database and what I need to know that is there a possibility that the graph auto scrolls to the current value and work like a real time graph and if not then can it be achieved through VB Code. Any...
  3. H

    FormControl Scroll Bar_Multiply the Value

    Hi Experts, I am using following code in a Form Control - Scroll Bar to get Min & Max value from a cell (has formula) to another cell as values. My Cell Value varies between 0 - 50,000... I believe scroll bar has a limitation up to 30,000 hence I am dividing my values by 10. Eg: 50,000 to...
  4. B

    listbox form control scrollbar question

    I want the scrollbar at the top, and I've seen solutions to use Sheets("Main").ListBoxes("List Box 1").scrolltop but excell says it's not a property or method. Does this only work with ActiveX? Can it be done with a simple form control? What about .topindex which the documentation from...
  5. mdfahiem

    Run-time error '1004' for a scroll bar (form control)

    Hi Gurus, I have a scroll bar (form control). There are cells which are updated based on the scroll bar value. I want to protect the work sheet and I have selected the cells to be protected and have them Locked in format cells --> Protection. When I scroll to next level, below message is...
  6. S

    Scroll Bar Extreme Frustrations!!

    Ok. So I already know about the highlight all the extra rows then hit Delete, CTRL+Home, and then Save the worksheet and this has worked every time I ever needed it to. However, now when I follow this process I gain like 200 more rows. So I'm like that's weird and I do it again, there by gaining...
  7. N

    Problem copying worksheets with scroll function and dynamic chart

    Hello I have a problem with duplicating a worksheet within a workbook that includes scroll funtions and dynamic chart calculations. I downloaded this template https://templates.office.com/sv-se/Månadsbudget-student-TM02930047 (it's in Swedish, but don't worry) from office's webpage to make a...
  8. A

    Dynamic x-axis range

    I can’t seem to figure out how to dynamically change the axis values. By this I mean that as the data progresses along the x-axis with a scroll bar, it plots 9 points, but the axis value keeps growing and it rescales the graph smaller and smaller as the range increases. In the initial scroll...
  9. J

    Userform - scroll to see full contents of a cell

    I am creating a userform and I am stuck on one part. The form will open up and pull in data from various spots. One of the cells will be text notes which will be of varying lengths. So when the form is opened I want it to be able to handle the fact that the cell might have 10 characters or...
  10. W

    Scroll Bar (Slider) Problem

    Hey everyone, I need to make my scroll bar move by 0.1 each time the arrows are clicked (I believe this is the 'small change' option) but when I go to enter it in it comes up with an error message saying "Invalid property Value". Also I've set the minimum to be -1 and the maximum to be 2 however...
  11. Prevost

    Worksheet Not Scrolling With Vertical Scroll Bar

    Hi There. I have a very annoying problem. When I scroll in a worksheet with the vertical scroll bar, the worksheet contents do not move with the bar. Once I release the mouse click from the vertical scroll bar, the worksheet jumps to that position. I would like the worksheet to move with the...
  12. C

    Scroll bar on a pivot table, possible?

    Hi Guys. Is it possible to connect a scroll bar form control to a working pivot table? Like you can still refresh the pivot table and all, but the rest of the table is scrollable. I just want to know if this is actually possible. I've already tried using the scroll bar but I use it with the...
  13. M

    Option buttons inside frames within a userform disappear partially when scrolling

    I designed a Userform, that appears automatically when user opens the Excel file. It shows Questions as text labels and 4 option buttons and Checkboxs within a frame for each question. it's an exam (MCQs) form. I am facing the following problem: when i scroll down through the userform, the...
  14. N

    Scroll Bar to Control Pivot Table

    I have a pivot table that has dates for column headers. My goal is to have a scroll bar that will take me through the history as I scroll (so, the filter would allow 10 months to show at once, and the scroll bar would "move" the allowed 10 dates are you scroll). I'm pretty green when it comes...
  15. T

    VBaA - Scroll Bars to change date in a cell

    Hi Bit of a novice at VBA so any help anyone can give me would be very much appreciated. I am trying to add a scrollbar to a spreadsheet that changes a date in a cell. I have managed to fix the bar to cell to change the date however I need to have a range of 31/01/2012 fixed as the minimum and...
  16. H

    Inserted picture linked to sroll-bar table

    Hi everyone, I would appreciate it if someone can help me with the following: I have a set of data that I represented it as a scrollable table. Every time I scroll the bar, the cost evaluation of the new year will appear. However, for each year I have a specific picture that needs to be...
  17. E

    Mirror User Form Scroll bar to Active Sheet Scrolling standard scroll bar

    I have a userform that acts as a toolbox for editing data that comes in regulary in excel sheets. All of the editing to the sheet is done through buttons/macros on the form. Currently there are two buttons for scrolling the sheet on the form so that the user doesn't have to go all the way to...
  18. G

    Using activeX control scroll bar to move line on spreadsheet

    I am trying to use an activeX scroll bar to move a vertical line across a set of graphs in a worksheet. I have a code that will move the line forward with each click of the scroll bar, but can't get it to move backwards when the scroll bar value decreases. Private Sub ScrollBar1_Change() Dim...
  19. D

    Vertical scroll bar too long, not resetting

    Hello, I have a worksheet with lots of data on it and have created a macro that toggles the data. There is a hidden column which has true/false depending on the toggle and the macro goes through this column and hides the row accordingly. However, once this is done the vertical scroll bar...
  20. L

    Scrolling option buttons

    Hi all I have created few option buttons which I would like to be scrollable I have created scroll bar and it work fine. But when I scroll down, my option button not moving How to make the button move together with the cells?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top