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

PDA

View Full Version : Scrolling down flowchart



KateMaz
09-03-2013, 02:04 AM
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

SamT
09-04-2013, 08:59 AM
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.

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

raj85
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