scroll

Good Morning Everyone I have a data table in one sheet and in another sheet I have a table to show the filtered data. I am able to use the Form Control scroll bar to change the data in the show table. The data in the show table is being reflected in a user form. But what I am trying to do now...

I have a worksheet with more than 2000 rows and sometime itis time consuming to locate for the last blank row. What I need is your help tocreate a macro that when the sheet is activated, the screen will scroll down tothe last blank row and ready for data entry. Data Entry starts on column...

Is there any way to scroll a frame on a userform when the screen used is a touchscreen? i.e. swipe to scroll, not tapping scroll bars.

Some of the comments in my cells are very long. Is there a way to immediately scroll to the last line when I open it? Also, once the comment is opened is there a way to do a find within it and have the cursor position itself at the found line? Thanks in advance to all those who reply. Dan

Hello everyone. I have a question regarding validations: How do I get my drop down to start at the top of the list when I engage the drop-down button? Currently when I click on it, the list pops up but it's at the end of the list and i have to scroll up each time? Any help is greatly...

When I make the ListWidth value equal to the Width value of a combo box I get horizontal scroll bars even though the text in the rows are smaller than the combo box?

Hello. I have the following bit of code and the print preview (10 total pages) works wonderfully on my laptop, Excel 2010, Windows 7. I have sent the workbook to people running Excel 2013, Windows 7 and also Excel 2016/Windows 10. Oddly, on their computers, the print preview only shows the first...

Morning all. I am using a bit of code to scroll through a sheet. It run in a loop and to stop it, I just press escape. How can I suppress the popup alert "Code execution has been interrupted"? Application.DisplayAlerts = False does not work... Here's the vba: Sub SlowScroll()...

Hello everyone, I have an Excel sheet where I inserted in a cell (C1) a list of values - this created a drop down where I can select the value that I want, then the table below is updated accordingly. I would like to add a couple of spin buttons to scroll between the values - one click instead...

Hi All I have an annoying problem to keep the userform scroll to the top (0), although I have used the code: Private Sub MultiPage1_Change() Me.ScrollTop = 0 End Sub and Private Sub UserForm_Initialize() UserForm1.MultiPage1.Value = 0 End Sub When the userform is loaded, it default the...

Here is my code to lock the scroll area and it does work but how can I get this to run without having to use a button to start the code. Sub SetAllScrollAreas() 'Update 20140326 Dim ws As Worksheet For Each ws In Application.ActiveWorkbook.Worksheets ws.ScrollArea = ws.UsedRange.Address...

Hi Guys, don't know what the poster has done here: https://www.mrexcel.com/forum/excel-questions/1048832-excel-vba-website-tr-td-loop.html but it looks as though the whole page is inside a set of code tags (or two) My response is 'trapped' in there too. It's a pain to scroll through the...

I have a freetext entry textbox (tried a cell) that users can enter details however i can seem to get it to bring up scroll bars. Any idea how I do this? Thanks

I have created a macro which scrolls through a worksheet a fixed number of rows and then returns to the top and scrolls again. I need the "fixed" (14 in the sample below) number of rows to be variable based on the row number of a cell which contains specific text : "Today is" Here is the...

Hi, I'm using the following script from another thread to try to have my worksheet (sheet1) scroll down to the row containing today's date on opening. Private Sub Workbook_Open() Worksheets(“Sheet1”).Select x = Format(Date, "dd/mm/yyyy") On Error Resume Next...

Hello, I am using excel 2010 and I can't scroll up or down while I'm in the formula bar to edit the cell, but I can move horizontally. My colleagues are using the same excel and they can scroll either way. I searched the internet for over a week and came up with no solution. To narrow down...

I'm trying to hide or turn off horizontal scroll bars in a listbox. It's a single column listbox holding one chrW(9660) and only needs to be about 20 wide. But the width must be 71 or more to not have a scroll bar. Any fix for this ? Thanks.

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

Hi ive got a form control scroll bar on my worksheet. For some reason, when I press the scroll bar once have the increment on both by page and single to increase by 1, it starts to keep scrolling. Sometimes it scrolls by 1 and other times it carries on forever.. im having to change it to a...

As always, Thank you to whom ever is able to help me in advance. I was hoping there was or is a way to have a an object scroll while the page is in freeze pane. So if i have a color coded list and my sheet is long, how can i get the list to scroll with the page with out having to use 12 Rows in...