scrollbar

Hi, We have an internal SharePoint 2013 installation with powerpivot galleries and the BI center installed. They seem to be working fine, however, when I deploy a workbook with slicers that are supposed to have scrollbars my Windows 7 IE users (IE 11) DO NOT see the scrollbars. This renders the...

hi, i am adding a scrollbar on a sheet. i just want a code wherein it places the scrollbar at a specified location as i want to keep the scrollbar just beside where my table ends. For eg column C. Can anyone guide here. Thanks

I'm using a form so theres no way to scroll down the screen while in the form. So i thought why can't you use the toolbox scroll bar on the form to scroll up and down the worksheet. I would love some ideas, i can't find anything on the net about this. thank you.

Very much a beginner here. I'm trying to set up a scroll bar that doesn't increment by a fixed number, but instead increments through a data series in a column. How do I modify my VBA code to do so? Any help is much appreciated! No such thing as overexplaining for me...

Hi all. I'm pretty new to the VBA game. I've got a large spreadsheet with many cells that need user input. A bunch of calculations are performed on subsequent worksheets, but I want the user to only see the fields they need to enter. I'm trying to write some code that will use a scrollbar (form...

Hi Guys, I was wondering if there's a such widget (in excel 2010) as a double-sided scrollbar control (activeX probably). Basically, I have a range, and I want to control the lower and upper limits of the range by dragging the 2 ends of a single scrollbar widget that has 2 sliders, one for the...

Hey there Mr. Excel board, This spreadsheet that I have been working on is up to about 1100 rows. Today, suddenly a ludicrous amount of rows appeared at the bottom of my spreadsheet- (All the way up to Row # 1,048,576!) As a result of this, my scroll bar on the right-hand side of my excel...

Good afternoon, I'm having difficulty with protecting a sheet that I have added a scroll bar to. The scroll bar allows users to change a date range on a calendar. I want to lock this sheet but still allow the user to use the scroll bar. Is there a way to change protection properties for the...

Can you set the page scroll height so that if you have hidden data the scroll height would only be until the last activerow so that if someone scrolled they wouldn't see by the row numbers that cells were hidden, they would have to manually arrow down etc... rather than dragging the scroll bar...

hello, I am trying to set the ScrollBar1.Value within ScrollBar1_Change(). When I set it to a constant, 2,3..... etc or a temp variable set to 2,3...etc the Scroll Bar works as expected. However, I am trying to set it to a variable, and when I try this I get an error. Here is the first...

Hello, I have a userform almost completed that chooses the "Top 20" Customers from a Pivot Table. I've assigned a macro to the folowing with no problem: "Refresh Pivot Table" "See Top 20 Customers" "See Bottom 20 Customers" "Reset Pivot Table" My difficulty begins right at after I've...

Hello, I have found great information in this forums but now im stuck. Im trying to make the command button search within the workbook for the value of cell H2. This is what i have right now, but instead of the input box i want it to automatically choose the value in cell H2 and search...

I am trying to add a scroll bar on Userform Listbox1 both (hoz + ver) but in the properties i cant find it. Please help. Thanks Pedie

Hi, On a User Form I have a Combo-box filled with names. The Userform can either be used in English (names are left-aligned, scrollbar at right) or in Hebrew (names are right aligned, scrollbar on the left side). The user can select the language by means of option buttons. In Excel 2003 all...

Hi Folks, I am trying to link the maximum values of a set of scroll bars (across many sheets in the same workbook) to a range of cells set to display the current maximum value. The maximum value for each scrollbar will change each month, necessitating this update. I have almost 100 scroll...

Aim I want to use a Vertical ScrollBar on a Modeless UserForm to scroll the Excel Workbook / Worksheet window in exactly the same way as the (Windows OS) Application window scrollbars move it. Similar speed. Similar proportion (though control length scaled down 6:1). And especially similar...

Hello, I am trying to input data to a graph a scroll bar. I seem to be nearly there but the graph doesn't seem to update as the scrollbar is being moved. It wants to wait until the movement has stopped. Is it possible to update the graph as the scroll bar is being whizzed around? Ta

hi, I was wondering if anyone has any ideas on how to accomplish this. I have created an interactive chart that allows the user to select the data being charted (using option buttons) It also allows the user to select the regions being plotted (ie i'm trying to show various economic data for...

The problem: I have a textbox and a listbox on a user form. When the user clicks on an item in the listbox the description of that item will appear in the textbox (done by VBA). When the text in the description textbox is longer than the box can display, the vertical scrollbar does not appear...