scrolling

  1. A

    Form View doesn't match Design View - Forced to Scroll When Unnecessary

    Hi all, I've been studying form properties, and can't find what is causing this issue. In Design View, all my buttons can be seen on a single page without the need to scroll. When I open up the Form View, there is a large bar of whitespace where my bottom buttons should be ... I can scroll...
  2. N

    Flickering/slow

    Hi All, My worksheet has close to 200 checkboxes and some hidden rows, and a couple textboxes. I believe that is what is causing this flickering/slowness I am experiencing just simply scrolling up and down the worksheet. Is there anything that can prevent this from happening?
  3. B

    can command button move with scrolling?

    if iam scrolling my sheets i want to move my command button to keep visible while scrolling is it possible?
  4. M

    Viewing Records in Form Issue

    Hello, I created a form in access and was scrolling through the records, but I don't see any records. There are 4 records in the table tied to this form, but while scrolling to the next record it is blank. What am I missing? I see the refID changing and the date reviewed is also changing but...
  5. R

    Scrolling bar in a single cell

    Hi everyone, I may not be wording my search correctly as I have not found the answer to this question. How do I create a scrolling bar for a single cell. I have a workbook with the month (R3) and would like to be able to use the scroll button on the mouse to select the proper month...
  6. E

    simultaneous scrolling among certain sheets

    Hi all, Is there a VBA code to have Excel scroll simultaneously among different sheets (not all sheets, only specific ones)? I would need something like the below but without having ALL sheets move their position... Sub SynchSheets() ' Duplicates the active sheet's cell position in each...
  7. M

    Scrolling Right and Left in Excel 2013 365

    Howdy! In excel 2007 and earlier excel had the ability to scroll right and left by simply 'nudging' the wheel of the mouse right or left [Yes I am aware you can also push the scroll wheel down and move the mouse in any direction, I don't like this method]. I'm currently using my corporate...
  8. J

    Preventing Zoom/Pan/Scroll

    Howdy. I've been researching and looking for a neat way to avoid users zooming, panning and scrolling. So far, refering to zoom, I found ways of "fixing" it, after a given action (change selection) The code I'm actually using is the following (inside the specific worksheet's, that i want to...
  9. T

    Excel inputs numbers when I'm scrolling using cursor

    Hi, I'm using Excel 2013 and whenever I'm scrolling through data using the cursor keys, occasionally it inputs a number into a cell. This is causing me a massive headache, as I'm working on really big models and as I'm scrolling through data it (very quickly) inserts a number often...
  10. T

    Cell Alignment Automatically Changing

    Hello, I have a spreadsheet that is center aligned, however, every time I scroll over the cells it changes them to be right aligned. It does this for every other line so in other words it only changes every other row into the right alignment. [/IMG]
  11. L

    Scrolling selected cell to top left position of unfrozen pane

    I have a big honkin' spreadsheet. By selecting Cell D7 and using the "Freeze Panes" command, I have ensured that the left 3 columns and the top 6 rows will always be on the screen. The rest of the spreadsheet is for data entry, and there can be hundreds of rows & columns. I have successfully...
  12. A

    Disable Scrolling while Macro is Running

    How do I disable scrolling while my macro is running? I want my screen/window to be locked when the macro starts and unlocked when the macro ends. However, I do not want to disable ScreenUpdating. Application.ScreenUpdating = False Set x = ActiveCell ***macro*** x.Select...
  13. B

    I want to scroll the screen using the toolbox scrollbar, any ideas?

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

    Creating a menu of values to insert into columns

    Hello, Normally I would begin my research by running a quick search on the forums but my question is a bit specific. What I wish to do is create a menu of items that will allow me to enter the quantity I want for that particular item and have that quantity pushed to the appropriate columns...
  15. B

    Scrolling around a spreadsheet

    A quick question. Is there a way to limit the number of columns and rows that a user will see and therefore limit the scrolling in a spreadsheet? Thank you
  16. M

    Bind Listview scrollbar with other scrollbar

    Hi, On VBA form I am using two listview controls(Listview version 6.0 from MSCOMCTL.OCX). I want to bind both listviews scrollbar together, so if I scroll one list view, other should scroll too. I think that is not possible with native VBA.But.. This could be done through using win32 API...
  17. L

    Excel - cant stop scrolling

    my Lenovo T1 laptop. Periodically in Excel, the scrolling wont stop, either left-right, or top-bottom. Sometimes (not always) it happens in other programs. I did spend about 30 min searching on internet but could not find a solution. Found plenty of "my scrolling doesnt work"........
  18. amrosales

    HTML assist? change date from static to new entry

    https://spreadsheets.google.com/spreadsheet/ar?&hl=en&w=1&id=tcCRNoWSKI8tAFScOp2pHFg.00535076764060981446.5898301702373296406&action=1&tile=1&rpert=20&srow=0&erow=34&scol=0&ecol=12&fprt=false&tfe=jc_213&gsessionid=-4fQOzhCjTQ This URL will take you to a employee timesheet I embedded in my...
  19. S

    Zoom Lock like Cntl key is pressed?!?!

    I have Excel 2007 and certain/most workbooks will zoom instead of scroll up/down when i roll the tracker on my mouse (what you'd expect if you were holding down the CTRL key). Here's the kicker. If you hold down the CTRL key, the worksheet will scroll up/down, instead of zooming...
  20. J

    Selecting Columns

    How do you select a column of data, for example Column A, row 1 through row 300. Instead strolling down column A, manualling selecting row 1 through row 300, is there a shortcut to select all the text in a particular column that avoids scrolling/

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top