scroll bar

I have an issue that is more of an annoyance than anything else, but I have a userform that allows users to select the departure time for shipments. When you click on the departure time within the main userform a second small userform pops up with time selection. Now for whatever reason on the...

Can i change excel's scrollbar(s) color? I have 2016, on Windows 10. Thanks!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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