+ Reply to Thread
Results 1 to 4 of 4

Is there such thing as a scrolling event?

  1. #1
    Forum Contributor
    Join Date
    04-11-2011
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    325

    Is there such thing as a scrolling event?

    I have several command buttons placed on one of my worksheets in the first two rows at the top left of my screen. I can freeze panes to keep them in place when I scroll down but I cannot do this when scrolling to the right. (Because there are several buttons there is a section of data that will always be shown; which I want to avoid.)

    I have searched google a bit but there doesn't seem to be many similar problems. If I wanted to keep the command button in a position relative to the sheets upper left visible corner what is the code I'd use?

    What I have is this.

    Please Login or Register  to view this content.
    Where Load_Page is the name of my first command button. This in itself is useless to me. But it is close to what I need. The question is... is there a reference to the top left of the visible screen that I could put in place besides Range("A1") and 0?

  2. #2
    Forum Contributor
    Join Date
    04-11-2011
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    325

    Re: Is there such thing as a scrolling event?

    The good news is I got pretty far after an hour of Google. Maybe someone can take me the rest of the way. I have other plans to attend to at the moment.

    Please Login or Register  to view this content.
    will take the command button Load_Page and put it in the top left of the excel sheet when I click on any cell in the worksheet. So if I am over in row IV and click a cell the button appears in the top left. However, I still want it to be dependent on when I release from using the scroll bar. If someone can point me in the right direction I appreciate it. Other then that Ill probably mark this solved in another 2 hours if nothing else comes up. (What I have is close enough.)

  3. #3
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Is there such thing as a scrolling event?

    You may find this helpful.

    http://www.cpearson.com/excel/DetectScroll.htm

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Is there such thing as a scrolling event?

    Wouldn't it be easier to use a UserForm? Once you place them, they don't move.

    http://www.cpearson.com/excel/FormPosition.htm shows some methods.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1