Consulting

Results 1 to 4 of 4

Thread: Scrolling down flowchart

  1. #1
    VBAX Newbie
    Joined
    Jun 2013
    Posts
    4
    Location

    Scrolling down flowchart

    Hello,

    Please can someone help me, I am trying to achieve is for the screen to follow the flowchart. So that each time that I press next, the workbook scrolls down so that I can see the next step/shape without having to manually scroll.

    I have attached the document so that you can see what I mean - please can someone help?

    Many thanks in advance!

    Kate
    Attached Files Attached Files

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Kate,

    I am sorry, but My Excel XP (2002) can't even run your code. Also I did not see any "Next" buttons on any sheet.

    At least this post will bump your question to the top of the list again.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Contributor
    Joined
    Dec 2009
    Location
    Sevastopol
    Posts
    150
    Location
    See the attached workbook with modified code of Module2.
    All modifications are commented with tag "ZVI".
    Attached Files Attached Files

  4. #4
    VBAX Regular raj85's Avatar
    Joined
    Feb 2010
    Location
    Mumbai
    Posts
    34
    Location
    Add below lines in your code to scroll down

    ActiveWindow.SmallScroll Down:=15
    You can aslo scroll up by using negetive number as shown below

    ActiveWindow.SmallScroll Down:=-15

Posting Permissions

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