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

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

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

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?

Hello, I am trying to dynamically set the value of the linked cell for a Scroll Bar. I dont mind if the scroll bar is form type or active x type. Basically I have a column with figures in each cell moving down: 15 19 23 56 I have a scroll bar I want the scroll bar to change the value in the...

The spreadsheet contains 3000 lines and the scroll bar has enlarged to as long as the whole spreadsheet. When trying to scroll down it takes 0.001 second to scroll way down to bottom line. It's too fast. Tried deleting empty cells by Control "-". The spreadsheet either freezes/crashes/ or just...

Hello! I currently have a button that creates a rectangle the size of the active cell at the activecell. Macro as follows. Sub Add_rectangle() Dim rng As Range Dim lab As Object Set rng = ActiveCell ActiveSheet.Rectangles.Add(197.25, 108.75, 42.75, 57.75).Select Set lab =...

Folks: This code fixes my scrollbars without having to save the document first, but I am getting an error: I carry over certain entries to a summary sheet, then delete the ones I don't want. On the summary sheet is a named range = the entire column AF. If I delete all the rows with populated...

I'm working on a project that uses scroll bars on a worksheet named "Interface" to change the values of cells on another worksheet named "Calculations". Because the final workbook will be used on PCs and Macs I'm using form controls instead of ActiveX. One thing users set is the projected...

Hi! does someone know a way to use two sliders on one scroll bar. Giving values to two different cells. For example I would like the left slider to select a starting month end the right one to select the ending month, possibly having restictions like it can not be less the the left slider...

Greetings, Apologies for asking about something which is probably quite easy, but I'm a complete newbie to VBA and am still trying to learn. I have to set four Scroll Bars which are conditional on each other, i.e. when a user scrolls on one of them (a percentage figure), the maximums of the...

anyone know how to allow the scroll wheel on the mouse to work in drop down menus. I have a data validation list that is quite long and when the user tries to select a value they have to click and drag the scroll bar vs. using the scroll wheel. Any ideas?

Hi I need a long note section on each spreadsheet of a workbook. So I need one text box with a scrollbar. How come I use that and how to format a text. It seems very easy but when I have tried I could not do that.Please help.;...

Hello, This is something I have been working on for days...It seems simple enough. I would like to add a scroll bar that will scroll a range, independantly of the main horizontal scroll bar. The range is a table from f10:ce25. Thanks in advance...

Hello, I'm trying to do something with a scroll wheel that is common on alarm clocks and other types of gadgets. I want to have the scroll wheel increment 1 unit at a time when clicked. However, the longer the user holds down the button, the faster it will increment. For example...

Hi I have a spread sheet which when I use the wheel on my mouse moves by a few lines at a time, is it possible to make it scroll a page at a time as its for a weekly hours sheet and I dont want to be able to see half of one and half of another. Thanks for any help given, also on another note...

I want to use a scroll bar in an activechart sheet. Inserting one using Command Bar => Forms => Scroll Bar Resulting in an "Activechart.shapes(Scroll Bar 1")" which does not allow control of the Max / Min propertiues and I am unable to read the slider value. Any Ideas??