scroll

Did a search and the latest answer was from 2005. Is there a way to use your mouse wheel to scroll through long drop downs? Excel 2010 Thanks!

Can anyone help me create a scroll area in excel 2011? I've been reading the steps, From the Developer tab, in the Control group click Properties Locate Scroll Area and enter the range you want to limit the worksheet to. Such as A1:Q30 However, in excel 2011 I do not see such button...

Afternoon, I ask some time ago about being able to scroll within a drop down list with mouse wheel. I was told it wasnt possible etc. I have just come across this, does this help us achieve this request ? http://www.mediafire.com/file/cdjhuyi6bqrf2s4/DDLS.mp4

My spreadsheet is set up to scroll from a button to a certain row number. That row contains specific information. However, when new rows are added or deleted, the button scrolls to rows above or below the correct row. I have the following code now: Sub View_9() ' View_Total Macro...

Hello, I have a macro which creates a new spreadsheet and saves as .xlsx. Among many other formatting tasks, one of the things the macro does is to set the scroll area to the used range on each tab. This all works perfectly but the only problem is, once the workbook has been closed and...

Evening, On my worksheet a have a few drop down lists and wondering if its possible to make the list longer. Example. I have say 50 items in my list,when i click on the drop down arrow it only shows 10 of them and i need to scroll down before i can select. It would be nice to just show say 30...

Hi, Im currently trying to apply conditional formatting to a table of data that changes via a scroll bar, the data ranges from years 2007-2016 consisting of Q1-Q-4. The scroll bar i have also ranges from the same years. I would like the conditional formatting to highlight the highest and...

Hi there, I have an ActiveX control in a worksheet that acts as a scroll bar which enables users to click through different month's worth of data in a dashboard. I just wanted to know if it is possible to have more than one cell in the 'Cell link' field, ideally a cell in a different tab. I've...

Hello, I can use this code to retrict the scroll area of a worksheet to the used range: Sheets(1).ScrollArea = Range(Sheets(1).UsedRange, Sheets(1).UsedRange(2, 2)).Address Say, for example the scroll area has been restricted to $A$1:$M$69. You can scroll down until row 69 is at the top of...

I can manually scroll using the scroll bar. If click out of excel and back into it, then mouse scroll will work. If I open up a userform and close it down, the mouse will then scroll. Upon opening/activating there is no code being executed. No forms are open when opening the document. All...

Hi, I have a macro and it perfectly run. however, the result is always shown at the right (latest column). image attached http://ibb.co/maG9L6 I tried to add the macro select.range("A1") or Application.Goto Reference:="R1C1" and it still not working. Is there anyone know how to make the...

My mouse is jumping as I scroll from cell to cell....any ideas

Hi guys, I am new to Excel and I am wondering if there is a way to freeze a row to the top when you scroll down until it becomes the top row? For example, I want to see row 50 frozen at the top only after I scroll down and row 50 comes on top. I only know that we can freeze top rows or...

Hi Everyone, Hope someone can help me. I want to be able the have a macro scroll the page to a name. Now heres my page set up Columns A to H are fixed using freeze Panes, I onwards are the columns with names in, The name I want to scroll to is in cell B5 (as in this is where the name is...

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

I cleaned up as much as I can for now. I need to edit the scroll and have it end at the last row number that Column C has data in. Instead of going down to 50 as I have now. So basically trying to scroll down columns A F & G to end when column C has data last. For example last data in column C...

Hi All, Is there a way to VBA ScrollArea all of the EVEN sheet numbers to AND ScrollArea all of the ODD sheet numbers to ?? Thank you! Pinaceous

Hi there, I would like to keep some entire rows still visible when i scroll down my excel sheet and cumulate them one after one. Eg. Rows 1, 4, 7 14, etc. Thanks a lot for your help. Fred

Hello guys, sorry if the question seems silly but for me it's very annoying... I have just changed the computer provided by my company and on the right of the Excel window (next to the scrolling bar) there is a thin border, this does not allow you to just go on the right limit of the screen...

Hi all, I am trying to create a way for users to be able to scroll from left to right to see a certain amount of dates and ALSO be able to scroll vertically to show only certain rows for those columns. I'm using the Index function and it's not working. Would I need Index/Match for this? Any tips...