Consulting

Results 1 to 3 of 3

Thread: How to set no. of line per scroll for different worksheet

  1. #1
    VBAX Newbie
    Joined
    May 2006
    Posts
    2
    Location

    How to set no. of line per scroll for different worksheet

    Hi,

    I have sheet 1 to sheet 5, is it possible to use some code to set the no. of lines to scroll per sheet without changing my mouse setting?


    eg. I want to scroll 8 lines/scroll for sheet 1, 10 lines for sheet 2, etc,

  2. #2
    Hi, WWII! Welcome to VBAX!

    I don't quite understand what your needs are.

    Do you want to set the mouse scroll so that whereever you are poiinting, when you move the wheel you will skip over, say, 10 lines?
    -OR-
    Are you trying to move to specific spots on the worksheet in the quickest possible manner?

  3. #3
    VBAX Newbie
    Joined
    May 2006
    Posts
    2
    Location
    Yes, I just want to set the mouse scroll so that whereever I am pointing, when i move the wheel, it will move down/up 10 lines per scroll for sheet 1, and 5 lines per scroll for sheet 2 etc, different sheet have different scroll lines,
    Or is it possible to set the mouse to move to a specific cell area to get this scroll activated?

    How to do this?

    I know how to move to a desire spot by using a macro recording,

    Thanks fo any expert help,
    Last edited by WWII; 05-23-2006 at 11:05 AM.

Posting Permissions

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