scroll

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

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

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

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

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

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

In a workbook with several sheets, I can't scroll up to row 1 in one particular worksheet. Can only go to row 2. Other sheets behave normally. Any suggestions? Split and freeze Panes are not activated. Thanks.

Hi all, Let's say I have a counter of two different brands, JG and OM. I have a horizontal scroll bar on a userform which I want to show the split between the brand allocation. If I have 300 allocations, and 200 are JG and 100 are OM, I would like the bar to look as follows...

Hi, I am trying to hide some rows and then freeze panes on mouse scroll. 1. User scrolls down 2. Hide rows 1-5 3. Freeze new rows 1-5 Is this possible? Sub FreezeRow() ActiveWindow.FreezePanes = False Rows("1:5").Select ActiveWindow.FreezePanes = True End Sub

I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've...

Have a cell(A1) with a formula consisting of two cells: +B1+B2 If selecting cell A1 and typing Alt+[ I get directed to cell B1. Is there any way (Shortcut) to be directed to the second cell instead?

Hi, I have a long ListBox and I have to scroll the UserForm to get to the bottom of the ListBox. Problem is that when I scroll down the focus is moved to scrollbar and when I click the bottom value on the ListBox the focus moves onto the ListBox and scrolls all the way up again. I would very...

OK, so, I need to tap some excel wizardry on this. I want everything (menu bar, tools, ribbon, the works) hidden. I only want the cells and maybe a scroll bar to be seen. I linked an image of what I imagine it to look like...

Hey everyone, I would appreciate some help on using the sheet change event with scrolling. For instance, how would I Scroll to the target cell that triggered sheet change event. One way to achieve is to use the following two lines ActiveWindow.ScrollRow = Selection.Row...

I have a workbook with over 100 sheets. I have some text on sheet1 (about 100 rows) that I want to link to one of the other sheet in that workbook. Same thing for sheet 2, 3, etc. I know how to add a link using Excel's built-in insert a hyperlink command. This presents you with a dialog box...

Can anyone tell me what action comes first with a form control scroll bar- the assigned macro or the action of the scrolling bar moving? if the scroll bar moves before the macro is ran, can you delay the action of the scrolling? or is there a way to have a part of the macro run first? Thank...

I am having an issue with my form control scroll bar. It works just as intended unless a user is entering data in one of the cells. If a user enters data in cells R77:V94 and does not hit enter before hitting the scroll bar, the scroll bar jumps to the max value. Why is this? I can certainly...

I have Excel Office 365. My question: how do I prevent scroll lock from "auto-disabling" after I save? Here's what happens: (1) I have scroll lock enabled on a spreadsheet, (2) I enter any new information on the sheet, (3) I click control + S to save my work, and (4) scroll lock automatically...

I need to be able to select between windows used in home remolding. I have several GIF images that I would like to scroll through and I want to use their file names in the bill of material. I also want to know if there is a way to change the aspect ratio based on the window's dimensions. My...

Good Morning Everyone, I was given an excel file that is password protected and I have the password. However, I am unable to scroll past certain points of sheets. When I drag my scroll bar it resorts back to a certain column. I am also unable to select an entire column or row. I tried a few...