VBA Express
Scrolling down flowchart [Archive] - VBA Express Forum


View Full Version : Scrolling down flowchart

09-03-2013, 02:04 AM

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!


09-04-2013, 08:59 AM

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.

09-04-2013, 06:51 PM
See the attached workbook with modified code of Module2.
All modifications are commented with tag "ZVI".

09-05-2013, 12:51 AM
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